- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -
MS Excel: Cells to a Table – No Mouse Required
Posted By April On June 13, 2011 @ 7:28 PM In MS Excel,MS Office Help | Comments Disabled
By now we’ve all found the Format as Table button on the Home tab of the Ribbon will take a range of selected cells in turn them into an easily and beautifully formatted table.
However, if you’re not one for the mouse then I do have a solution for you.
Next time use the Shift key + arrows, Home, Ctrl, etc… (or a combination of them) to select the range of cells to be converted to table format.
Now try Ctrl + T or Ctrl + L.
Either one of these will open the Create Table dialog box where you’ll find the range of selected cells already entered into the data location field.
Click OK to confirm your decision and… BAM! You’ve got a table ready for editing, filtering and formatting.
Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com
URL to article: http://www.worldstart.com/ms-excel-cells-to-a-table-no-mouse-required/
URLs in this post:
 Image: http://www.worldstart.com/ms-excel-cells-to-a-table-no-mouse-required/msex_create_table_dialog/