Excel on MacBook no drag and fill?

%3CLINGO-SUB%20id%3D%22lingo-sub-2074984%22%20slang%3D%22en-US%22%3EExcel%20on%20MacBook%20no%20drag%20and%20fill%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2074984%22%20slang%3D%22en-US%22%3EHi%20guys.%20I%20recently%20got%20a%20MacBook.%20I%E2%80%99m%20an%20admin%20and%20IT%20teacher%20so%20rely%20heavily%20on%20spreadsheets.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20drag%20and%20fill%20doesn%E2%80%99t%20work%2C%20when%20I%20drag%20the%20little%20box%20in%20the%20corner%20it%20comes%20up%20blanks%20(my%20formula%20is%20definitely%20correct%20and%20works%20fine%20on%20a%20PC).%3CBR%20%2F%3E%3CBR%20%2F%3EI%20looked%20in%20the%20Edit%20and%20then%20Fill%20menu%20and%20it%20only%20brings%20up%20these%20options%20(see%20image)%20-%20it%20still%20doesn%E2%80%99t%20allow%20the%20drag%20and%20fill.%20It%20means%20I%20need%20to%20do%20each%20cell%20one%20by%20one%20which%20just%20isn%E2%80%99t%20okay.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20please%20help%3F%20Need%20my%20drag%20and%20fill%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2074984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor
Hi guys. I recently got a MacBook. I’m an admin and IT teacher so rely heavily on spreadsheets.

The drag and fill doesn’t work, when I drag the little box in the corner it comes up blanks (my formula is definitely correct and works fine on a PC).

I looked in the Edit and then Fill menu and it only brings up these options (see image) - it still doesn’t allow the drag and fill. It means I need to do each cell one by one which just isn’t okay.

Can anyone please help? Need my drag and fill
0 Replies