How to Unhide A Single Hidden Row Or Column in Excel Worksheet with Example.
There is question here that is there an easy way or way to unhide a single column when multiple columns are hidden?
The Answer is Yes, there is an easy way.
If an excel user have a multiple rows or columns hidden and he/she needs to unhide just one. Some people unhide all hidden columns or rows and then re-hide all except the one they want. So there is no need to adopt such a long method, Here is an easier way...
To unhide a single column:-
1) In the Name box*, type a cell reference (e.g. D5) for any cell in the hidden column and press Enter. This will select that cell even though it is in a hidden column;
*(the white space to the left of Formula Bar)
Unhide a single row or column in Excel |
To unhide multiple hidden columns:-
In Step 1 above, type a reference to the columns in the Name box.For contiguous columns, enter the top left and bottom right cells separated by a colon (e.g.. D5:E5).
For non-contiguous columns, enter a cell from each column you want to unhide separated by a comma (e.g. B5,G5).
Related Keyboard shortcuts:-
F5 opens the Go to dialog (can be used instead of Name Box to enter cell reference)
CTRL+9 to hide selected rows
CTRL+0 to hide selected columns
CTRL+Shift+( to unhide selected rows
CTRL+Shift+) to unhide selected columns
NOTE:- This Shortcut doesn't work in Excel 2013
ReplyDeleteAmazon SAP-C01 Dumps stuff is fitting for each one with a wide scope of inheritance capacity of the field. We even have composed with the guide of using the utilization of stuff that helped you now no longer with taking examinations so hard. However, taking your appraisal basically and used SAP-C01 online test engine for preparing so your desires satisfied that even have outperformed AWS Certified Professional test which is noteworthiness these days is dynamically extending and accordingly interest for IT guaranteed will in like manner increase. As development gets more amazing, the ability of specialists will similarly get more unpredictable. Transforming into an IT expert will give an edge among others regardless, yes it is difficult to be guaranteed anyway not plausible. So in case you have to lead the current reality and be ready for some other time, you should look at our Amazon SAP-C01 Dumps. We moreover have an online test engine where you can give free practice tests.