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 ...
To apply data validation rules to a selected cell or range, head to the "Data" tab on the ribbon, and click the top half of ...
You can use Google Sheets keyboard shortcuts to save time and make the most of the spreadsheet program.