How to Make Page Layout the Default View in Excel 2010

Excel 2010 has a handful of different views that you can select between when viewing the data in a spreadsheet. We have previously shown you how to switch to the “Page Layout” view in the program, but that method will only allow you to change the view for the current sheet. If you create a […]

How to Turn Off the Auto Fill Options Button in Excel 2010

The Auto Fill feature in Microsoft Excel 2010 is very useful when you need to fill a series of cells with a series of numbers. In fact, it can be a real time-saver when you need to number rows in a spreadsheet.   But the Auto Fill feature often includes a pop-up Auto Fill Options […]

How to Only Have One Worksheet by Default in Excel 2013

Most workbooks in Microsoft Excel 2013 will include 3 worksheets by default. Using multiple worksheets within an Excel workbook is helpful when you have a lot of related data that does not belong in the same spreadsheet, but a large percentage of Excel users will rarely ever use more than one sheet within their workbooks. […]

How to View a List of Worksheets in Excel 2013

Using multiple worksheets within an Excel 2013 workbook is common when you have a lot of data that you want to keep in the same file, but which may not fit properly on one sheet. But as you begin to add more and more worksheets to one workbook, it can be difficult to navigate between […]

How to Split Full Names Into Two Cells in Excel 2013

Properly formatted data can make it much easier to complete tasks in Excel 2013, but it is rare that the data we have is ideally suited for the work that we need to do. This is common when working with names in Excel, as many companies and individuals will store full names in one cell […]

How to Remove Cell Indentation in Excel 2013

Spaces preceding data in a cell can make your spreadsheet look less professional, and may even create potential problems for people working with your data. This indentation can occur if you have copied and pasted the data from another source, or if if has been introduced to the worksheet by accident. Fortunately the amount of […]

How to Unhide a Worksheet in Excel 2013

It’s common to hide a worksheet in Excel 2013 if it contains information that should not be edited, if the data on the sheet isn’t relevant, or if there are too many tabs at the bottom of the workbook, and you only want to display the most important ones. But you may eventually need to […]

How to Remove the Quickbooks Tab in Excel 2013

The navigation within the Microsoft Excel 2013 program is centered around a series of tabs at the top of the window. Each of these tabs includes a number of tools and settings that you can use to interact with the data in your spreadsheet. There are some tabs that are displayed on every default installation […]

How to Change the Starting Page Number in Excel 2013

The default behavior for page numbering in Excel 2013 is to number the first page of the spreadsheet as “1”, then continue increasing that number for each successive page of the spreadsheet. But you might be working on a spreadsheet with a team of people, or including it in a document that already has a […]

What is the Height of a Row in Excel 2013?

The rows and columns in your spreadsheets in Microsoft Excel 2013 are all the same height and width by default. According to Microsoft’s website, the default width of columns is 8.43, and the default height is 12.75. The unit of measurement for column width is characters, and the unit of measurement for rows is points. […]