Microsoft Excel is a great spreadsheet program. For most of us, it can be even faster to do certain things if we know some of the shortcuts. Here are a few quick hitters that might make things easier for you.
If you have a spreadsheet where you’re using multiple tabs, so many that you end up having to scroll through your tabs at the bottom to find what you’re looking for, there’s an easier way to access that information. Go to the bottom left of your spreadsheet and right click on any of the arrows. It will bring up a list of all of your tabs. And if you have more than 20, you’ll see more, and you can click on that to go to the tab you want.
Sometimes you need to copy information from your spreadsheet onto another spreadsheet. What most people do is click in a cell and then goes through all sorts of gesticulations to try to go over every single cell that has information in it, then copies and pastes it into another spreadsheet. A quick way to get past that is to click on the box between 1 and A, and it will highlight the entire sheet. Then just right click, copy, and paste wherever you want.
Do you sometimes have problems getting your rows or columns to be the same size? If so, what you can do is right click on the column or row that’s the perfect size, select either row height or column width, and it will tell you what measurement it’s presently at. Then all you have to do is right click on the column or row you want to change and put in the number. If you want to change multiple rows or columns, put your mouse on the first letter or number, drag your mouse over how many of them you want to change, right click on them as a group and select your option, then type in the number and it’ll automatically adjust all of them at the same time.
If you happen to have a column with a lot of text, and you can see it all at the top but on your spreadsheet it looks like a long line going across multiple columns, you can change that. What you do is right click in your cell and go to Format. Once there, click on the tab that says Alignment. Once that opens, click in the box that says Wrap Text. Then you’re good to go, but you’ll want to make sure the column width is what you want it to be.
Article Directory : http://www.articlecube.com
