Have hundreds (or even thousands) of rows of data—and need to select them all? You can give yourself a finger cramp from tons of endless clicking and scrolling. Or, you can use this simple trick to select all cells with one single click. All it takes is clicking on that light gray triangle that appears in the top left corner of your spreadsheet. Click it once, and every single cell in the spreadsheet will be selected. It’s as easy as that!
There’s nothing worse than having your text run outside of the width of the column. And, needing to click and drag to resize the column to the perfect width over and over again can be a pain. Fortunately, you can do this instantly. Place your mouse on the line between two column markers (C and D, for example) until you see a symbol that looks like two opposite-facing arrows. With that symbol, double click on that line that separates the columns, and the column will automatically be resized to fit the widest piece of text within that column. Note: The same hack can be used to adjust the height of rows!
Just like every software has keyboard shortcuts, excel has its own too. There are many of them but below are the most relevant and widely used. Enjoy!
If you want to insert excel data into words without creating a link-and-embed process, you can paste the data as a graphic. To do this, you can use Word’s paste special tool but you can also use Excel with the following steps:
If you want to insert a screenshot into your worksheet, just follow the following steps:
By now, you should know that a spreadsheet comes with an option to add or insert a graphic element like chart, bar, etc. If you don’t know how to, the following steps are an easy walk-through.
Sometimes you will encounter a situation where you have to write the same thing repeatedly and doing that manually would be excruciating. But don’t worry with easy excel tips and tricks, you can avoid that and also get the desired result. The following steps allow you that:
When you want to change your rows and columns but there are a lot of them, moving one by one would be a tiresome thing to do. Here is how you simply can save your time to do that:
Say you’ve got a column full of names, first next to last, but you want two columns that break them out.
There are much faster ways to select a data set than using the mouse and dragging the cursor, especially in a spreadsheet that contains several rows or columns.