![]() ![]() Step 4: Right-click one of the selected column letters, then choose the Hide option. ![]() Step 3: Continue holding down the Ctrl key, then click the column letters of other columns you want to hide. Step 2: Hold down the Ctrl key on your keyboard, then click the column letter of the first column you want to hide. Step 1: Open the Excel file containing the columns you want to hide. The steps in this article were performed in Microsoft Excel for Office 365, but will work in most other versions of Excel as well. Can I Hide More than One Column at a Time in Excel? Our guide below is going to show you how to use the Hide functionality in Microsoft Excel for Office 365 so that you can hide more than one column at a time. This is helpful if you are trying to consolidate your data to make it easier for readers to understand, but you don’t want to delete that data. Microsoft Excel for Office 365 gives you the ability to hide more than one column at a time. Right-click one of the selected column letters, then choose the Hide option.Click additional column letters to select them, then release the Ctrl key when you’re done.Click the column letter of the first column you wish to hide. ![]() Hold down the Ctrl key on your keyboard.This guide is going to show you how to hide more than one column in your Excel spreadsheet.
0 Comments
Leave a Reply. |