ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Sheet - Hidden Border or Frame (https://www.excelbanter.com/excel-discussion-misc-queries/2154-excel-sheet-hidden-border-frame.html)

Priscilla

Excel Sheet - Hidden Border or Frame
 
On an spreadsheet created by someone else, there is a hidden border or box
frame that only shows when previewed or printed. The border or frame
surrounds 5 columns of data on a full sheet.

The bordertoolbar does not help. How do I get rid of this.

Thank you.



Dave Peterson

Maybe it's a textbox or a rectangle???

You could select that sheet
Edit|goto|special
click objects

If you have multiple objects on the sheet, hit the tab key to traverse among
those objects.

Priscilla wrote:

On an spreadsheet created by someone else, there is a hidden border or box
frame that only shows when previewed or printed. The border or frame
surrounds 5 columns of data on a full sheet.

The bordertoolbar does not help. How do I get rid of this.

Thank you.


--

Dave Peterson

Dave Peterson

And if you find one you don't want, hit the delete key when it's the only one
selected.

(You may find it useful to change the zoom to something small (10%????), too.)

Priscilla wrote:

On an spreadsheet created by someone else, there is a hidden border or box
frame that only shows when previewed or printed. The border or frame
surrounds 5 columns of data on a full sheet.

The bordertoolbar does not help. How do I get rid of this.

Thank you.


--

Dave Peterson


All times are GMT +1. The time now is 04:16 AM.

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