Learn how to adjust the settings and make changes to the spreadsheets that you are editing in Microsoft Excel 2010.
Microsoft Excel has a couple of different potential layouts, though many people will only ever see one. A layout option that can be really confusing involves a complete reversal of the spreadsheet layout. If you have a spreadsheet with Excel columns backwards and row numbers on the right side, then our tutorial below can show … Read more
If you have previously frozen the top row of your spreadsheet so that it was easier to identify the data in your cells, then you might be finished working on the spreadsheet. But if you are worried that less experienced Excel users might be confused about that frozen row, then you may want to unlock … Read more
Did you previously hide a worksheet because it contained important information that you didn’t want anyone to edit? Or perhaps you simply have too many worksheets in one of your workbooks and wanted to make it easier to find the sheets that you needed. Regardless of your reasoning, you may find that you need to … Read more
While your primary concern when working with data in an Excel spreadsheet may be ensuring that the data is correct, you may also need to consider its physical size. This can be tough to visualize on the screen, which could leave you looking for a way to add an on-screen ruler. When you are adjusting … Read more
If you spend a lot of time in Microsoft Excel then you have probably either forgotten to include a decimal point at some point, or you have worked with data where one was missing. While these mistakes are often easy to catch, they can also be simple to overlook. One way to reduce potential errors … Read more
Microsoft Excel is a great way to manage and edit large amounts of data. The row and column structure, combined with all of the different formulas and comparison tools make it one of the more useful applications that you will use in school or work. But one area where people have difficulty with Excel involves … Read more
New Microsoft Excel files often contain a couple of blank tabs where you can add data. But if you only need one tab for your current project, then you may want to get rid of the other ones to avoid confusion. Fortunately, you can learn how to delete a sheet in Excel and get rid … Read more
If you have finished creating or editing a spreadsheet in Microsoft Excel and then gone to print it out, you might find that it hasn’t printed all of the rows. Excel is notoriously difficult to print from, but often those issues are related to the spreadsheet not fitting properly on the page, or not including … Read more
Adjusting the size of the cells in your spreadsheet is a pretty common occurrence, so you will eventually need to know how to make a row bigger in Excel 2010. Whether it is due to an increased font size or multiple lines of data, it is something that can make your spreadsheet much easier to … Read more
Being able to edit a visible property for one of your cells or worksheets in Microsoft Excel typically involves switching between the different tabs on the ribbon at the top of the window. There are a lot of tools and options on those menus that will typically allow you to achieve your desired result. But … Read more