Solved Excel short cuts in selecting a table

January 7, 2016 at 06:16:58
Specs: Windows 7
I have a spreadsheet of data that I am going to turn into a pivot table. I need to select all the data in the spreadsheet, instead of selecting and highlighting all of the data manually, is there a command shortcut that will do it for you?

See More: Excel short cuts in selecting a table

Report •

January 7, 2016 at 07:01:07
if you want to select all the data on a worksheet you can hold Ctrl and then press A

is this what you are asking or am i missing something?

Report •

January 8, 2016 at 12:22:12
✔ Best Answer
You can also click the little box directly above the row numbers, to the left of the column letters. One click, all cells selected.

You can also use F5 (Go To) which offers quick access to any Named Ranges in the workbook as well as some built in Selection options via the "Special" button.

If you need to select a specific region/regions on a consistent basis, then create Named Ranges and select them via F5 or the Name Box above Column A

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question