Block Out Columns Contract For Free

Select a row or rows that you wish to hide. If they are non-adjacent rows, select them by pressing Ctrl and clicking on the specific row. Right-click on it, and from the menu, select the option Hide. To unhide a row, select all the cells, and go to Home ? Format ? Hide & Unhide ? Unhide Columns.

Select all blank columns - click on the first column letter, press Shift, and then click the letter of the last blank column. Right-click the selected columns and choose Delete from the pop-up menu.

Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected columns, and then select Hide.

Hide Columns in Excel Using a Keyboard Shortcut ?The keyboard key combination for hiding columns is Ctrl+0. Click on a cell in the column you want to hide to make it the active cell. Press and hold down the Ctrl key on the keyboard. Press and release the 0 key without releasing the Ctrl key.

How to hide unused columns in Excel Select the column to the right of the last column with data. Press Ctrl + Shift + Right Arrow to highlight all the unused columns to the end of the sheet. Press the Ctrl + 0 key combination to hide the selected columns. Done!

Step 1: Select the blank columns, to select the blank columns press Shift and press the down arrow to the row upto you want to select the column. Step 2: Then right-click on the selected column. A drop-down will appear (as shown below). Select the Delete button.

To collapse a column in Excel, you need to follow these simple steps: Select the column(s) that you want to collapse. Click on the collapse icon or use the shortcut keys "Alt+Shift+Right Arrow" The column will now be hidden and replaced with an arrow icon at the top of the adjacent column(s)