Microsoft Excel Question: Download Questions PDF
I know I can use the fill handle (the small black box in the lower-right corner of the range) to copy data and formulas in Excel, but is there a way to use it to clear ranges in Excel?
Answer:
To do this you will need to select the range you want to clear. Once you have it highlighted then drag the fill handle (the small black box in the lower-right corner of the range) up or to the left to clear what you want in the range.
Download MS Excel Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Is there a way to set up a toolbar button in Excel to access Page Setup? | Is there a way that I can close all spreadsheets in my Excel file at once? |