David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link. Contact David at or follow him on Twitter. Select Cells > Format > Hide & Unhide > Unhide Columns. Note: The double line between two columns is an indicator that you've hidden a column.
Right-click the selected columns, and then select Hide. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Select the Home tab from the toolbar at the top of the screen. Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Click Fill on the left pane, then click the Patterns tab on the right. When the GoTo window appears, enter A1 in the Reference field and click on the OK button.
Excel 2011 mac unhide rows for mac#
To do so, we’ll select the names, and then carry out these steps:ĭavid H. Secondary-click the bar graph and select Format Chart Area from the menu. Question: How do I unhide row 1 in a sheet in Microsoft Excel 2011 for Mac Answer: Select Edit > Go To from the menu at the top left of the screen. Our goal is to highlight the second and any subsequent times that a name appears more than once on a list.
Let’s say that we have a list of names, such as shown in Figure 1. In this article I’ll explain how, along with instructions on identifying duplicate values in Excel 2003 and earlier.
Excel 2011 mac unhide rows how to#
A reader then asked how to format only the second and any subsequent instances. Although easy to implement, this technique identifies all instances of a duplicate value. We must perform the below steps to unhide a row in Excel with ease: First, we need to select one row on either side of the hidden row.
In a previous article I explained how you can use Conditional Formatting in Excel 2007 and later to highlight duplicate values with just a couple of mouse-clicks. A keyboard shortcut to unhide a row in MS Excel is 'Ctrl + Shift + 9' without quotes.