Occasionally you might find that you have laid out data in a spreadsheet in a different manner than you actually need it. This can be frustrating, and the prospect of essentially redoing the exact same task again might not be appealing. Fortunately you can convert a row into a column in Excel 2013 by taking […]

I have found that spreadsheets I receive from other people often have some formatting that is already applied. One big one is the print area, which can be a really frustrating thing to solve when only part of your spreadsheet is printing. Many times these formatting issues due to the reuse of spreadsheets that were […]

Text that you enter into the cells of an Excel 2013 spreadsheet is typically oriented from left to right. But there may be situations where you need your text to display sideways to make it easier to read. Excel 2013 has a rotation button that offers several ways in which you can turn your data sideways. […]

Manually entering a series of numbers into an Excel row or column can be tedious. It’s easy to start typing too quickly and enter an incorrect character, or even to enter the wrong number entirely. Excel 2013 has a tool called the fill handle, however, which can make it much simpler to fill a series […]

While everyone that uses Microsoft Excel has their own tendencies and preferences, it is common among many of these users to choose a blank workbook when starting a new project. The templates available on the Start screen can improve specific tasks, but you may find that you aren’t personally using them very often. Therefore, the […]

There are a lot of different ways to modify an Excel spreadsheet to make it print better. Our guide to printing in Excel covers many of those areas, but manually adjusting column and row sizes, or tinkering with margins until you have achieved the right balance of settings can be both tedious and frustrating. Excel […]

Excel workbooks with multiple worksheets are a great way to coordinate data that might not necessarily belong on the same worksheet, but that is relevant enough to a single topic that it merits combination. Typically you can navigate between different worksheets within a workbook by clicking the tabs at the bottom of the window. But […]

Using borders and gridlines in your spreadsheet can provide a clean and simple way to separate information in different cells. But adding borders to your cells is not the same as adding a border to a text box, as Excel treats those two objects a little differently. A text box in Excel 2013 is its […]

Excel spreadsheets rarely print how you want them to, and properly configuring a spreadsheet for the physical page is often cited as one of the bigger frustrations for Excel users. There are some quick ways to simplify the process, such as fitting a spreadsheet to one page, but that isn’t always practical for larger worksheets. […]

Excel spreadsheets show a pattern of lines on the screen that represent the perimeters of the cells. These are called gridlines, and they make it easier to distinguish different cells from one another. But gridlines can be overridden by cell fill colors, so you may be looking for a way to regain those cell perimeters. […]