ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I want to change the selected print area but it will not allow me (https://www.excelbanter.com/excel-worksheet-functions/62198-i-want-change-selected-print-area-but-will-not-allow-me.html)

jeclss

I want to change the selected print area but it will not allow me
 
was created by someone else. I can edit like add numbers and information.
But it will not allow me to edit the print area, I get only the WHite plus
sign(like) as a cursor not the usual cursor to drag and change the print
area.

Dave Peterson

I want to change the selected print area but it will not allow me
 
Tools|Options|Edit tab
Check "allow cell drag and drop"

(are you jayphx, too?)

jeclss wrote:

was created by someone else. I can edit like add numbers and information.
But it will not allow me to edit the print area, I get only the WHite plus
sign(like) as a cursor not the usual cursor to drag and change the print
area.


--

Dave Peterson


All times are GMT +1. The time now is 02:15 AM.

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