0
One way is to use the fill handle and drag to the right. You can also select the formula you want to copy and cells to the right of it. Then press Ctrl - R and it will fill out to the right, like using Ctrl - D to copy down.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
How to repeat a formula in new cells on an Excel document?
Either drag the formula cell down the column, or copy (right-click) the cell then paste (right-click) in other cells.
How do you move a horizontal line of print in Excel down the page without deleting the line of print?
You can cut and paste it.
Key that can be used in place of the paste button?
Ctrl + v also, EDIT go down to paste or right click then to paste The ENTER key
Key that can be used in place of paste button?
Ctrl + v also, EDIT go down to paste or right click then to paste The ENTER key
How do you switch Excel sheet from left to right?
Press Ctrl - Page Down.
How do you copy and paste and send in an email not using hot mail?
All I can tell you is how it works on my ISP. Right click on the thing you want to copy and paste, scroll down if you need to, to select it, while keeping the right mouse button held down, then click on Copy. Then go to where you want to paste it, and click Ctrl and the letter V at the same time, or right click and click on Paste.
How do you convert Open Office file to Excel file?
When you come to save your spreadsheet - use 'Save as' instead of save, and select the correct excel version from the drop-down menu.
How can you copy the text in Microsoft Word?
You can highlight to text (drag the cursor over it) and then right-click and click 'copy', and then right click again where you want to paste it and click 'paste.' An alternative option is highlighting the text and then hold down the buttons Ctrl and C and then find where you want to paste your work and hold down Ctrl and V. Hope this helps!
In Excel I want to search for the first empty cell in a column then paste a value into that cell can you help?
To find the first emply cell, select the cell at the top of the column, then type End Down.
How do you insert a new cell in excel?
Right-click then select ''Insert" and choose shift cells to right or shift cells down, depending on what way you want to do it.
In Excel I want to search for the first empty cell in a column then paste a value into that cell. can you help?
Copy the value. Click within the destination column (within the start of the data). Press control and down arrow. This will take you to the last line of continuous data. Press the down arrow once and now you have selected the first empty cell in that column. Paste the value.
How can you copy things of the computer without right clicking?
Hold down Ctrl and press C to copy. Ctrl V to paste.
