create a button for paste special in excel 2016 mac

#Create a button for paste special in excel 2016 mac for mac#
#Create a button for paste special in excel 2016 mac mac#

It’s simple to apply existing formatting to a new column. For example, I want the “Total” column I’ve created to also have bold font and the dollar signs like the “Price Per Gallon” column that already exists on my spreadsheet. Let’s say that I need to create another column in my spreadsheet-and I want to apply the same formatting that’s in an existing column.

#Create a button for paste special in excel 2016 mac mac#

Shortcuts on Mac may vary depending on your OS, or on older versions of Excel.

#Create a button for paste special in excel 2016 mac for mac#

Note that this shortcut works on Excel for Mac and PC 2016. Hitting the up arrow twice brings us all the way back to the top.Ĭommand (or Ctrl on a PC) + Up Arrow Once: Brings you to the last line of data that appears before a blank rowĬommand (or Ctrl on a PC) + Up Arrow Twice: Brings you to the top of your worksheet Why do you have to hit the up arrow twice? Hitting it once will bring you to the last row of data that appears before an empty row (which, in this case, is the last line of our data). Pushing Command (Ctrl on a PC) and the up arrow twice will bring you back to the top of your spreadsheet. And, when you’ve finally made it? The last thing you want to do is scroll all the way back up to the top. When you have a particularly large data set, you know that it takes a while (and quite a bit of scrolling) to get all the way to the bottom of your worksheet. Note: The same trick works for percentages! Just hit Ctrl - Shift - % to include the percent sign with each digit. With that simple trick, your entire column will be displayed with the dollar sign, any necessary commas, and two points after the decimal point. Simply select the column that contains the digits you want to re-format, and then use the below keyboard shortcut to automatically format that entire column to dollars: There’s no need to do this one at a time. Right now, there isn’t a dollar sign displayed in front of each number, and you’d like to insert one there. Let’s say that you have an entire column that contains digits that represent the same thing-like dollar amounts, for example. Note: The same hack can be used to adjust the height of rows! 4. 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. 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. And, needing to click and drag to resize the column to the perfect width over and over again can be a pain.įortunately, you can do this instantly. There’s nothing worse than having your text run outside of the width of the column.

Click it once, and every single cell in the spreadsheet will be selected.

Or, you can use this simple trick to select all cells with one single click.Īll it takes is clicking on that light gray triangle that appears in the top left corner of your spreadsheet. You can give yourself a finger cramp from tons of endless clicking and scrolling. Have hundreds (or even thousands) of rows of data-and need to select them all? This works with one or multiple cells selected. Save yourself some clicks when formatting by instantly adding a cell border.

Select a cell with an active formula and see which cells are directly referenced by that formula. Speed up your number crunching by quickly summing numbers in a contiguous range. Here are a few of our favorites: Autosum all selected cells