Most users quickly find out that pressing the Enter key won’t let you start text on the next line, like it does in Microsoft Word. Sometimes you’d like to add a line break within a cell, even if the cell is wide enough to fit all the words. Excel Hack #3 – Start a New Line In a Selected Cell To resize multiple columns, simply select the columns or rows, then double-click next to any of the selected columns to expand the columns all at once. Just hover your cursor to the right of the column you want to resize and double-click. It’s easy to resize each column individually by clicking and dragging with the mouse, but there’s a faster way. The standard column sizes in Excel don’t leave a lot of room for text, so you’ll often see columns that look like this: If you’re looking for more time-saving hacks, also check out our articles covering other Microsoft Office programs:ġ3 Time-Saving Hacks for Better (and Prettier) PowerPoints Excel Hack #1 – Select Everything with a Single ClickĮver need to quickly select your entire spreadsheet? You can do it with a single click, just by clicking the arrow in the upper left corner of your spreadsheet.Įxcel Hack #2 – Resize Columns to Fit With 2 Clicks Here are nine of our favorite Microsoft Excel hacks that make quick work of resizing columns, changing number formatting and even embedding a spreadsheet into a Word document. While most of us aren’t die-hard spreadsheet junkies, learning some time-saving shortcuts can help you get things done faster and more efficiently in Excel. Whether you’re crunching sales figures, importing an email list, or analyzing data for a monthly report, chances are you need to use Microsoft Excel for some of your day-to-day work.
0 kommentar(er)
