Hello friends, I am Sameer, and welcome to my blog in this article, I will teach you how to hide columns in excel.
Thanks to my advice, you have finally learned how to use Excel and enjoy discovering new features of this powerful spreadsheet processing software every day. Well, today I want to make my contribution to this approach journey to Excel by showing a feature of the program that you probably did not notice. If you want How to move columns and rows in excel.
What I mean The ability to hide entire columns of spreadsheets by making their contents invisible without deleting them. How do you say impossible? He was right then. You still do not know How to hide columns in Excel and you need to fix it right away ... now I will show you how to do it!
Do not worry about which version of Office you are using - for the manual I use the Excel 2019 edition for Windows and macOS (which at the time of writing is the most recent available), but the instructions in the guide are also valid for previous versions of Office, up to 2007. Furthermore, I will also explain how to use the old Excel 2003, in Excel Online (the free web version of the well-known Microsoft software) and in the Excel application for mobile phones and tablets. In short, you really have nothing else to do; take five minutes of free time and dedicate yourself to reading this manual! Have fun! If you want How to become a computer genius/hacker in 2021.
How to hide columns in Excel for PC and Mac
If you want to learn how to hide columns in Excel and you are using a recent version of Office (from 2007 to 2019), all you have to do is run the software through the link in the Windows Start menu or in Launch the macOS Launchpad and enter the spreadsheet you plan to work on (or alternatively create a new document by double-clicking the appropriate item).
At this point you are ready to act: click on the letter corresponding to the column you want to make invisible, press it in full to select its to format at the top right of the Excel toolbar (inside the tab) casa ) and select Hide and Expose the items > Hide columns from the menu that appears.
You have now hidden the selected column, but not removed its contents. To make it visible again, just enter the letter of the hidden column, followed by the number 1 (Eg E1 if you hid the column y ) in the menu in the upper left corner (below the toolbar) and press the Enter key on the keyboard from your computer. At the time, on the menu Format> Hide and Expose and select the article Discover columns from the menu that appears.
and Office 2003 and precedents, the procedure is practically identical, but the menu design changes. This means that to hide a column in Excel, you have to click on the letter with the latter, go to the menu format (above) and select items Column> Hide from the same
To make the hidden column visible, type the letter of the hidden column followed by the number 1 (Eg E1 if you hid the column y ) in the menu in the upper left corner (below the toolbar) and press the button present on the computer keyboard. At the time, go to the Format> Column menu and select the Discover item from the menu that appears to complete the operation.
How to hide columns in Excel Online
Are you using a computer on which Excel cannot be installed? Do not be discouraged: if you have an urgent need to customize a spreadsheet and hide columns in it, you can use Excel online, a "lightweight" and appreciative version of Microsoft Excel that works directly from the browser. The only requirement to use the service is to have a Microsoft account. If you have not yet set up a Microsoft account, you can fix it right away by following my dedicated guide on the subject. If you want 137 shortcut keys in computer.
After creating a Microsoft account to use Excel Online, you need to upload the document you want to modify, OneDrive, Microsoft's cloud storage service that offers 5 GB of free storage. Log in to your OneDrive and drag the browser to XLSX files / XLS you want to edit with Excel Online.
So wait until the document is complete and select the document within OneDrive to open it directly in Excel online. On the other hand, if you want to create a new spreadsheet or edit a file that has already been uploaded to OneDrive, sign in directly to Excel Online and sign in with your Microsoft account (if necessary).
Once you have opened the spreadsheet you want to work on, click to hide a column in Excel Online paper accordingly (to select it in full), then press the format button at the top right (in the tab) located casa on the toolbar ) and select Hide and Expose Items > Hide Columns from the menu that opens.
Changes to the document will be automatically saved online in OneDrive. Click the button to download the file offline record, top left, select the item save as from the menu that appears on the side, and press the button Download a copy.
If in doubt, click the button to display the hidden column Search and select located at the top right of the Excel Online toolbar (on the casa tab ) and select the Visit item from the menu that opens.
In the subject box that appears on the screen, enter the coordinates of the first cell of the previously hidden column (eg G1, if the hidden column is the G ) and of the present, to select the latter. Then press the format button in the top right and select the elements Hide and Uncover> Discover Columns from the menu that opens to complete the operation.
How to hide Excel columns for phones and tablets
As you already know, Excel is also available as an application for mobile phones and tablets. To be precise, it is available for Android, iOS y Windows 10 Mobile and can be used for free, as long as you have a device with a size equal to or smaller than 10.1 ”(otherwise, a subscription to Office 365, from 7 euros/month, which also gives access to additional functions). If you want How to secure computer system.
That said, to hide a column in a spreadsheet with the official Excel app, you need to download it from your device's store (for example, Play Store on Android, App Store on iOS, or Microsoft Store on Windows 10 Mobile), start it and open the file to take action. For example, you can open both files in the internal memory of the device and files offered on supported cloud storage services OneDrive, Dropbox, or Google Drive (use the card open ).
After selecting the document to respond to (or composing a new document), tap on paper that matches the column to be hidden (to select all), then do a second tap and select the item to hide from the menu that appears on the screen. If you do not immediately see the "Hide" item in the on-screen menu, scroll to the right with the corresponding arrow.
If you then want to show the previously hidden column again, tap on a letter related to an adjacent column to the latter (to select it in full), make a second tap and select the item To discover from the menu that opens. If you do not see the item "Discover" immediately in the menu on the screen, scroll with the arrow to the right.
All changes to the file will be automatically saved in the file. When creating a new document, click on the arrow icon located at the top left.
I hope you understand how to hide columns in excel. If you have any problems so do comments I will as soon as possible respond you and resolve your problems.
If you are interested in tech so also visit here for more knowledge about tech.