Method #1: Hiding Rows in Microsoft Excel

Steps and Guides:

Hide unused rows so that only working area is visible

Press Ctrl + Shift + Down arrow to extend the selection to the bottom of the sheet. Press Ctrl + 9 to hide the selected rows.

​

Method #2: Hiding Columns in Microsoft Excel

Steps and Guides:

Hide unused columns so that only working area is visible

Press Ctrl + Shift + (Left/Right Arrow) to extend the selection to the Last Column of the Sheet. Press Ctrl + 0 to hide the selectedcolumns.

​

​

That's It, for more Information about these Article Check~Out the Video below!!!!!

​

Last Updated: April 02, 2023 @ 10:04 AM