Not every problem is big. Sometimes, it’s the little repetitive gotchas that drive you nuts. This month, I’ll share a few problems that seemed large to the readers but have simple solutions. Unhide columns and rows Mark had trouble applying the technique I shared in a previous post called, '.' When unhiding columns or rows, you select the adjacent columns or rows first. That’s a problem if the hidden column or row is column A or row 1. You can’t select the column to the left or the row above, because neither exists. The technique I shared works, but Mark was trying to unhide columns A though D, not just column A. If you have adjacent columns or rows hidden, you have two options: • You can unhide column A using the technique shared in the linked article above and then unhide the remaining columns as you normally would by selecting the adjacent columns. • You can unhide the continuous block of columns using the technique shared in the linked article above, which is more efficient that the first method. Let’s walk through the second method with a short example where columns A through D are hidden: • First, hide columns A through D by selecting those four columns and right-clicking the selection. Choose Hide from the resulting contextual menu. Now, you’re ready to unhide them. • In the Name box — to the left of the Formula bar — enter A1:D1 (as shown in Figure A). Notice that the first visible column is E. Figure A • Press Enter. How to make bootable pen drive for mac os x lion from windows 10. OS X Lion and its downloadable installer create a conundrum for Mac users who would like to have bootable media from which to install Lion. The reason many people want to have a bootable Lion installer is to create clean installs: that is, to install Lion on a freshly formatted hard drive that doesn't contain any previous OS. Doing so will select A1: D1, but you won’t see that happen. Mfc-j8250w driver for mac. The columns are still hidden. • Click the Home tab. From the Format dropdown in the Cells group, choose Hide & Unhide. In Excel 2003, choose Column from the Format menu, and choose Unhide. • Select Unhide (as shown in Figure B) and Excel will expose all four hidden columns at the same time. ![]() Display or hide Row & Column headings in active worksheet or all worksheets One click to hide or show the Ribbon Bar/Formula Bar/Status Bar in Excel Kutools for Excel’s Work Area utility can maximize the working area and hide the whole Ribbon Bar/Formula Bar/Status Bar with just one click. This is the most easy way to unhide columns in excel. Follow the below steps to use this method: First of all select one column on either sides of the hidden column. Now, with all these columns selected right-click on the column header. This will open a popup menu, select the ‘unhide’ option and the hidden columns will be visible.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |