Excel Sheet has 2^20 Rows and 2^14 Columns. Instead of Using the blank cells appearing. It is better to hide all the unwanted blank cells. How:? Step 1: Select the Row from Which you want to hide Step 2: Press Ctrl+Shift+Down Arrow to Select all the rows till 2 ^20 Step 3: Right Click and Select Hide Step 4: Select the Column from which you want to hide Step 5: Press Ctrl+Shift+Right Arrow to Select all the columns till 2 ^14. Step 6: Right click and Select Hide You are Done now. See the Demo Below: Back to MS Excel>>
A Project Management Blog with free video tutorials and setups on various tools to enrich your knowledge in project management skills and much more softwares