Ads 468x60px

Wednesday, July 25, 2012

Show only few rows & columns in Excel [Quick tip]

Show only few rows & columns in Excel [Quick tip]:
Each new sheet in MS Excel comes up with a 1,048,576 rows and 16,384 columns. While it has a certain binary romantic ring to it (2^20 rows & 2^14 columns), I am yet to meet anyone using even half the number of rows & columns Excel has to offer.

So why leave all those empty rows & columns hanging in your reports?
Would it not look cool if your reports showed only few rows & columns as needed, like this:
Show only few rows & columns in your Excel reports
Today, lets learn how to do this.

Showing only few rows & columns in Excel

Step 1: Select the column from which you want to hide.
Step 2: Press CTRL+Shift+Right Arrow to select all the columns till XFD.
Step 3: Right click and hide
Step 4: Select the row from which you want to hide.
Step 5: Press CTRL+Shift+Down Arrow to select all rows until 2^20
Step 6: Hide the rows too. And you are done!
See this demo:
Bonus tips: Learn how to make better Excel sheets

0 comments:

Post a Comment