Microsoft Office: Excel is an extensive program that can be incredibly helpful when working with tables, spreadsheets, and graphs. It can be a difficult program to learn, as its' functions and capabilities are so vast that new users can quickly become overwhelmed. Here are a few tips and tricks we use in the IT department that can hopefully make life easier for you.
Input The Same Data Into Multiple Cells
If you ever need to input the same thing into more cells than one, there's a simple solution to do it all at once; that way you don't waste time retyping the same thing over and over.
Hold Ctrl while you click on all the desired cells and then type your information into the last selected cell.
After typing your information, hit Ctrl+Enter to automatically place the same information into all selected cells.
Wrap Your Text To Fit The Cell
Have you ever tried to type something in Excel, and for some reason it wants to extend past the cell? There's a simple fix to that as well: Wrapping your text.
Click the cell you wish to use, and type your information into it as normal.
After that's done, click Wrap Text at the top of your screen to fit your text into the cell. (Hint: You may have to adjust the size of the cell to fit lengthy words by dragging the edge to the right.)
Autofill Your Cells
Sometimes you'll find yourself inputting repetitive data such as names, dates, or other numerical information. Excel can detect patterns and fill in the rest of your column, granted the pattern is correct.
After typing in 2-3 cells of your column, Excel should be able to take it from there. Move your cursor over the bottom right corner of the selected cell and it should turn into a black "+"
Click and drag down the desired amount of cells, and Excel will autofill the rest of the cells with data that fits the pattern detected.
Keyboard Shortcuts
Similar to our
Microsoft Word blog post, Microsoft Excel has a plethora of keyboard shortcuts that can save you time and effort when using the program. Here's a few that we find useful in our day-to-day excel tasks.
Tyler Parker
Social Media & Marketing Student Assistant
Web & Digital Strategies