Have you ever printed a spreadsheet in Excel and it was aligned at the left side of the sheet? In some cases this is perfectly fine, but in other situations this could look bad or unprofessional. This can leave you trying to learn how to center a worksheet horizontally in Excel. Printing has long been … Read more
Hiding columns is a great tool in Microsoft Excel when you have data that you can’t delete, but don’t want to leave visible. But you may be wondering how to unhide columns in Excel 2016 if there’s something in one of those columns and you need to edit or delete it. Knowing how to hide … Read more
Making a large Excel spreadsheet more user-friendly can be difficult. But one way that you can improve it is by learning how to freeze a row in Excel so that it stays visible at the top of the sheet. Have you ever worked on a large spreadsheet where you needed to keep scrolling back up … Read more
Have you been working on a spreadsheet, editing and adding data, only to print it and find that it isn’t including all of your data? This can be a confusing issue to encounter, as it is typically caused by a setting that was applied to that spreadsheet by someone else that was working on it. … Read more
Using comments and the other review tools in Microsoft Excel provides you with some convenient ways to collaborate on a project. Other users are able to leave comments on data in your cells, allowing you to see their thoughts and possible apply some changes. But if a comment was added inadvertently, or if there’s an … Read more
Microsoft Excel gives you the option to specify the formatting for your cells. This is helpful if you are entering percentages, or currency, as anything that you enter into a formatted cell will already be formatted how you need it. You might already know how to format a single cell in Excel, but the same … Read more