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
Excel has a combination of default settings that are meant to appeal to a large number of users. One of these settings is the view, which is how new spreadsheets look when you create one. But if you prefer a different view and always change it, then you may be wondering how to change Excel’s … Read more
A default spreadsheet in Microsoft Excel 2013 is going to display rows and columns of cells that are separated via a sequence of lines. These are called gridlines, and are useful for making data easier to read. But these gridlines aren’t going to print if you don’t change the default settings, which can leave you … Read more
Excel workbooks are actually collections of different spreadsheets that you can use to organize data within one file. But the sheet navigation at the bottom of the window takes up valuable screen real estate and, if you want that extra space to be able to view more cells at once, you might decide to hide … Read more
Sometimes when you are editing an Excel file you are working with sensitive information. Since anyone with access to your computer or the Excel spreadsheet would be able to view that information, it can be helpful to apply an Excel password to the file. But it may be necessary to later learn how to remove … Read more