To do this, with the 1% cell still copied, select the cells containing the values you want to convert from whole numbers into percentages. If your data is formatted as an Excel table, hover over the ...

Excel's spin button lets you quickly increase or decrease a value in a cell without having to type it manually. It can be ...