Hello ExcelForum Members,
My worksheet contains the following data.
Cell A1 = 65
Cell A2 = 85
Cell A3 = 115
Applied the formula for Cell C1 as =A1*2
Q: After this, I would like to drag the formula to cells C2 and C3, referring to cells A2 and A3 respectively. But I couldn't see the '+' symbol at the right bottom part of the cell C1 after applying the formula.
Do I need to change the settings anywhere to get this drag facility enabled ?
hi kktheblogger, welcome to the forum. go to the Windows icon -> Excel Options -> Advanced -> Enable fill handle and cell drag-and-drop. that might be the problem
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks