Click column B’s header cell and drag the mouse pointer to the left.Don’t panic, column A isn’t gone forever, and there’s more than one way to unhide it: Selecting just column B won’t select column A. That works fine until you try to unhide column A, as there’s only one adjacent column, column B. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and then select Unhide. You’re really selecting three columns: the hidden column and both columns on either side of it. Select the columns that are adjacent to the hidden column. Unhiding a column takes a bit of specialized knowledge, but it isn’t difficult. To hide a column, select it, choose Column from the Format menu, and then select Hide. SEE: Download: Build your Excel skills with these 10 power tips (TechRepublic) Hiding a column tucks data out of sight without interfering with its function. Even you won’t want to see all of it all the time. Confidentiality aside, sometimes endless data is just a nuisance. Not everything in your worksheet needs to be privy to everyone. Fortunately, there are two simple tricks for unhiding it. It does not store any personal data.The secret to unhiding column A in an Excel worksheetĪfter you hide column A, it might seem like it's gone forever. The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category "Performance". This cookie is set by GDPR Cookie Consent plugin.
The cookie is used to store the user consent for the cookies in the category "Other. The cookies is used to store the user consent for the cookies in the category "Necessary". The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly.
0 kommentar(er)
