How to Change Page Size in Excel 2010

The Normal view in Microsoft Excel 2010 is simply a large, continuous grid of cells that are organized into rows and columns. This view makes it difficult to determine where the page breaks will occur when you go to print your spreadsheet, as the Normal view is intended mainly for viewing on a computer. But […]

How to Switch to Page Layout View in Excel 2010

When you are working on a spreadsheet in Microsoft Excel 2010, the focus is usually on the data that you are adding, and the information that you are trying to find. But if you are creating a spreadsheet that you need to print and share with colleagues, then you also need to be aware of […]

How to Add the Current Date to a Cell in Excel 2010

Last updated: February 8, 2017 The Excel current date shortcut is one of the more useful, yet least-frequently-used options (at least in my experience) for many types of spreadsheets. If you have a spreadsheet that you update periodically in Microsoft Excel 2010, then you may also have a column where you keep track of the date […]

How to Create a Drop-Down List in Excel 2010

If you are entering data into a spreadsheet, or if you are creating a spreadsheet for others to use, then it is typically a good idea to make everything as easy as possible. One good way to do this is with the inclusion of drop-down lists. When you have a cell that can only have […]

How to Add a New Worksheet in Excel 2010

The Microsoft Excel files that you have saved on your computer, and that you occasionally share with work colleagues or teachers, have file names with an .xls or .xlsx filename extension. This entire file is known as a workbook. Each Excel workbook can contain multiple different spreadsheets called worksheets. You can navigate between these worksheets […]

How to Turn on Automatic Calculation in Excel 2010

Are you working with a spreadsheet in Microsoft Excel 2010 where you change a cell that is included in a formula, but the result of the formula does not adjust to reflect your change? This occurs because the settings for formulas in the workbook have been set to manually calculate. This can be the preferred behavior if […]

How to Change a Worksheet Name in Excel 2010

Splitting data up into individual worksheets in a Microsoft Excel file is an efficient way to organize information. It also prevents you from needing to work with multiple files when dealing with related data. But when you have multiple worksheets in a workbook, it can be difficult to distinguish between them using Excel’s default naming […]

How to Put Parentheses Around Negative Numbers in Excel 2010

When you are working with a lot of data in Microsoft Excel 2010, it is often beneficial to format certain types of data so that they stand out. If, for example, you have a spreadsheet that tracks balances of accounts, then you may be most interested in the accounts that have a negative balance. Fortunately Excel […]

How to Hide Sheet Tabs in Excel 2010

Worksheets are a great way to separate pieces of information in Excel 2010, but still keep the data somewhere close if you need to access it later. It also provides a convenient place to store data that you might need for a VLOOKUP formula. But not every situation calls for a multi-worksheet Excel file, and […]

How to Hide the Scroll Bars in Excel 2010

When your Excel worksheet starts to fill up more than the visible cells on your screen, then you will need to a way to view the cells that are hidden from view. You can do so by navigating from cell to cell with the arrows on your keyboard, or by using the vertical and horizontal […]