how to delete excess rows and columns in excel 2011 for mac

Delete Excess Rows And Columns In Excel 2011 Manual Formatting Can
Delete Excess Rows And Columns In Excel 2011 Mac OS X

Delete Excess Rows And Columns In Excel 2011 Mac OS X

As far as I can tell, the columns in Excel for Mac OS X (V 15.22) go on for infinity.

Delete Excess Rows And Columns In Excel 2011 Manual Formatting Can

For those stuck with Excel on Mac OS X, however, manual formatting can still be used to improve the look of your tables.

One of the most useful steps is to hide unused cells, mimicking the look of Numbers.

To hide cells in Excel for Mac, first create your table, making sure to leave room for expansion if necessary.

Now we need to select all columns from this starting point to the end of the spreadsheet.

Because Excel gives users spreadsheets with tens of thousands of rows and columns, well use keyboard shortcuts to quickly jump to the end.

With the rightmost empty column selected, press and hold the Shift key and then press Command Right Arrow.

This will jump you to the end of the spreadsheet while the Shift key automatically selects every cell in between.

With your cells still selected, go to Excels Menu Bar and choose Format Column Hide.

Youll now see all the cells to the right of your data disappear.

With the bottommost cell selected, press and hold Shift and then press Command Down Arrow.

This will jump you to the very bottom of the spreadsheet and select all the rows in between.

Finally, head back up to Excels Menu Bar and choose Format Row Hide.

Youre now left with a spreadsheet that features only cells containing your data, resulting in a much cleaner look.

If you need to expand your table, or simply dont like the new look, you can easily unhide the cells.

First, click the top-left heading cell that looks like a white arrow pointing to the bottom-right corner.

Clicking this cell will select all cells in your spreadsheet, both hidden and not.

Once selected, go to Excels Menu Bar and choose both Format Column Unhide and Format Row Unhide.

In our example the hidden cells were empty, but these steps can also be used to hide cells that contain data.

This can be useful for quickly hiding irrelevant or sensitive data during a presentation, for example.

In either case, note that hiding data in this manner is not a secure solution, and these steps should only be used to hide data for purposes of convenience.

How to Hide Cells in Excel for Mac OS X Tanya says: May 22, 2016 at 7:42 pm Im trying to set my view to only the cells that I use.

I did like you said, held down Shift then pressed Command Right Arrow, and it does NOT select all the columns to the right.

Just for grins, I tried the left arrow, and it selects 1 column as a time every time I press the left arrow.

I also tried Control Shift Right arrow, and it selected only the 3 columns to the right.

How To Delete Excess Rows And Columns In Excel 2011 For Mac