Content

• Steps

This wikiHow teaches you how to apply publicity to an entire column using the full version Google Sheets website on the desktop.

Steps

1. 

   to create a new spreadsheet.

2. 

   
   
   Enter the formula in the first cell in the column.
   • If you have a header row, don't enter your formula there.

3. 

   
   
   Click a cell to select it.

4. 

   Drag the cell handle toward the end of the data in the column. Click the small blue square at the bottom right of the cell and drag down through the entire cell where you want to apply the formula. When you release the mouse button, the formula from the first cell is copied to each cell in the selection.

5. 

   
   
   Use a combination of keyboard shortcuts. If the column is too long to stretch or you want to apply the formula to total column in the worksheet, please:
   • Click the cell containing the formula.
   • Click the first letter of the column.
   • Press Ctrl+D (Windows) or ⌘ Command+D (Mac).
   advertisement