The cells in your Microsoft Excel spreadsheet are split up into rows or columns that run horizontally or vertically across the screen or the page. You can type data, or copy and paste data, into your cells, then you can format it or perform mathematical operations upon it. But you might discover that you need … Read more
Adding text boxes in Microsoft Excel may seem odd, considering the layout of a spreadsheet and the way that the application is generally. But you can definitely encounter situations where text boxes are a preferable choice for some data or information. The ability to move the text box alone can make it appealing, and you … Read more
Making a spreadsheet print properly can be difficult. As the file grows larger and the data uses more pages, readers might have trouble remembering what information belongs to which row. One way to improve this is to set a column to repeat the left side of each page in Excel. No matter what you use … Read more
Print areas in Microsoft Excel are a good solution when you need to print some of the data in a file, but not all of it. But occasionally a print area has been set and is no longer correct. Fortunately, you can use a similar process to remove a print area from your Excel spreadsheet … Read more
If you are just entering the job market, or if you are looking to make a career change, then you have probably determined that a lot of the available jobs require some kind of computer training. The actual extent of the necessary skills are going to vary wildly depending upon the type of job you … Read more
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. … Read more
Sometimes you will have data in a spreadsheet that you don’t need to display, but you don’t want to delete. This is the perfect situation for using the “hide” feature in Microsoft Excel, which will keep the data in the sheet, but remove it from view. But if you haven’t had to hide something before, … Read more
Have you ever meticulously entered a lot of data into a spreadsheet, only to find that you need to add something between two existing rows? You may have solved this issue by cutting all of your data and pasting it one row lower, or you might have even deleted a bunch of data to make … 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 … Read more
Printing in Microsoft Excel can be a frustrating endeavor. The default settings are often not ideal, which can leave you wondering how to do things like how to center a worksheet horizontally or vertically on the page in Excel 2010. By default, Microsoft Excel 2010 will print your spreadsheet based upon how you have configured … Read more