Getting a spreadsheet to correctly fill a single page can be quite the task in Microsoft Excel. If you’ve ever tried to drag around columns or rows or even hidden them, then you likely know how frustrating it can be. Luckily there is a fast method of how to fit to one page in Excel… Continue Reading How to Fit to One Page in Excel 2013 (3 Different Options)
The default cell size in Microsoft Excel is rarely going to be correct for the data that you are entering into a cell. You might have more characters, or more rows, which can leave you needing to know how to enlarge cells in Excel. How to Make a Cell Bigger in Microsoft Excel Open your… Continue Reading How to Enlarge Cells in Excel 2010
Adjusting the height of rows or the width of columns in Microsoft Excel is a common activity. But if it’s something that you do a lot, then you might be looking for a faster way. Luckily there is an AutoFit Excel shortcut that can make it much simpler for you to automatically adjust the height… Continue Reading How to Use the AutoFit Excel Shortcut for Columns and Rows
It’s really easy for your column widths and row heights to be sized incorrectly. You might drag a row or column divider by accident, or you might have a lot more data in a column than it can handle by default. Luckily you can learn how to AutoFit all columns in Excel 2013 and quickly… Continue Reading How to AutoFit All Columns in Excel 2013 (An Easy 4 Step Guide)
Despite the annoyance that many people have for caps lock and people that write in all uppercase letters, it does have its place in certain situations. One of those times is when you are entering information into a spreadsheet. if your current data is all in lowercase but you need it in capital letters, then… Continue Reading How to Change Lowercase to Uppercase in Excel 2010
If you’ve ever used a worksheet in Excel that contained a table, then you’ve probably noticed how useful of a tool it can be. But if you’ve been trying to make one yourself but have been struggling to figure out how, then our Microsoft Excel Create Table guide below can point you in the right… Continue Reading Microsoft Excel Create Table Guide
While the standard structure of a spreadsheet is ideal for storing small bits of data in each cell, you may eventually need to store long strings of data. This can leave you trying to figure out how to expand all rows in Excel so that you can easily view all of your content at once.… Continue Reading How to Expand All Rows in Excel 2013
When you start typing data into blank cells in Microsoft Excel, it can make some decisions about what you are typing. Occasionally it might recognize numerical data and determine that you are entering currency or dates, then apply that type of formatting to it. Other times you might be typing names or locations, or any… Continue Reading How to Convert Text to Numbers in Excel for Office 365
Being able to edit a visible property for one of your cells or worksheets in Microsoft Excel typically involves switching between the different tabs on the ribbon at the top of the window. There are a lot of tools and options on those menus that will typically allow you to achieve your desired result. But… Continue Reading How to Hide Tabs in Excel 2010
Microsoft Excel can be a difficult application to work with when you need to print a spreadsheet. One common problem involves getting your column to fit correctly. Fortunately, you can learn how to print all columns in Excel on one page. How to Fit All Columns on One Page in Excel 2010 Open your Excel… Continue Reading How to Print All Columns in Excel 2010 on One Page