ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   AUTO FILL DOES NOT WORK ON PREVIOUS EXCEL WORKBOOKS (https://www.excelbanter.com/excel-worksheet-functions/92917-auto-fill-does-not-work-previous-excel-workbooks.html)

LINSPIRATION

AUTO FILL DOES NOT WORK ON PREVIOUS EXCEL WORKBOOKS
 
WHEN I OPEN A WORKBOOK THAT WAS CREATED WITH A PREVIOUS VERSION OF EXCEL
(PREVIOUS TO 2003), A COLUMN THAT I USE AS A DATE COLUMN DOES NOT ALLOW ME TO
USE THE FILL OPTION. THE 2002 VERSION DID ALLOW IT. WHAT HAPPENED ? DID
UNCLE BILL PULL A FOOLIE?

Michael

AUTO FILL DOES NOT WORK ON PREVIOUS EXCEL WORKBOOKS
 
Try Holding the Control key while you do the dragging of the cell.

"LINSPIRATION" wrote:

WHEN I OPEN A WORKBOOK THAT WAS CREATED WITH A PREVIOUS VERSION OF EXCEL
(PREVIOUS TO 2003), A COLUMN THAT I USE AS A DATE COLUMN DOES NOT ALLOW ME TO
USE THE FILL OPTION. THE 2002 VERSION DID ALLOW IT. WHAT HAPPENED ? DID
UNCLE BILL PULL A FOOLIE?



All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com