ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I remove a search bar on Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/122572-how-do-i-remove-search-bar-excel.html)

OU Pitboss

How do I remove a search bar on Excel?
 
I got this page that has a search bar on it. It is not attached to any
specific row or column but I can move it up if I remove rows. I cannot move
it by cutting, copying, or any other method. Help.

Lauren Giles

How do I remove a search bar on Excel?
 
I have a very rudimentary solution. First, I assume that you can't highlight
the search bar, right?

So, create a new page. Select all of the original (CTRL + A (I like keyboard
shortcuts)) and paste the whole thing (CTRL + V) it in the new one. The
search bar *may* magically disappear. I think I recall doing something
similar when I had a random floating image on a spreadsheet that wouldn't go
away (and I had NO IDEA where it had come from, as well).

If that doesn't work... I have no idea.

Hope that helps.

"OU Pitboss" wrote:

I got this page that has a search bar on it. It is not attached to any
specific row or column but I can move it up if I remove rows. I cannot move
it by cutting, copying, or any other method. Help.


Jim Cone

How do I remove a search bar on Excel?
 
What is a search bar?
Do you have other search bars in the workbook?
If so, what do they do?
Has the bar "worked" before and now stopped working?
What version of Excel? Windows or Mac?
Does the workbook have macros in it?
Is it your workbook or did it come from elsewhere?
If elsewhere, have you asked about it over there?
Does the workbook ever "crash"?
What is the size of the workbook?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"OU Pitboss"
<OU
wrote in message
I got this page that has a search bar on it. It is not attached to any
specific row or column but I can move it up if I remove rows. I cannot move
it by cutting, copying, or any other method. Help.


All times are GMT +1. The time now is 08:32 AM.

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