Unhide first column in excel shortcut 2011
Freezing an Excel column typically locks or freezes the position of the column so that it doesn't scroll through the database while navigating the sheet. It helps in comparing or reading data from different parts of the sheet with easy navigation.
What is the Freeze Columns feature in Excel?įreezing Excel columns is one of the useful features to increase the readability and productivity of data within a worksheet. Before we move on to the methods, let us first briefly discuss the use of the Freeze Columns feature and how it can help us increase the readability of our Excel worksheets. We implement these methods using Excel 2010 however, they can be used similarly in other versions of MS Excel as well. In this tutorial, we will learn various step-by-step methods that will help us to lock or freeze columns in Excel. This is where freeze columns can be helpful. When we work around common data sets around the sheet and navigate to the very right side of the worksheet, we may not see the corresponding headings. When working with very large data sets within an Excel worksheet, it often becomes difficult to track, remember or compare the information. An Excel workbook consists of several worksheets where each sheet can store large data records within multiple cells.
#Unhide first column in excel shortcut 2011 software#
Login to Windows with a new user profile and see if problem is resolved.MS Excel or Microsoft Excel is powerful spreadsheet software that helps users record large amounts of financial data. If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.Ĥ. Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away. Type "? application.StartupPath" without quotes and press enterģ. Same can be also be accessed through View > Immediate WindowĤ. If Immediate Window is not visible, type CTRL+G. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)ģ. Note - If the above path is not applicable for your installation, you need to find XLSTART path. Now open Excel and see if the problem disappears or not. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. irst try Quick Repair (takes 5 - 10 mins), if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)Ģ.