ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   stuck (https://www.excelbanter.com/excel-worksheet-functions/70809-stuck.html)

darkbearpooh1

stuck
 

excel worksheet stuck in its own little windows window. can not move
it?
ever happen to anyone else? maybe something i did by accident? problem
is half the page isn't visable and seems like you should be able to
click and drag it back into position but does nothing


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=510927


darkbearpooh1

stuck
 

ok i am free at last free at last lol......

um apparently when you protect workbook it does that . don't i feel
stupid


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=510927


darkbearpooh1

stuck
 

ok i am free at last free at last lol......

um apparently when you protect workbook it does that . don't i feel
stupid


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=510927


darkbearpooh1

stuck
 

free at last free at last.... yes i am stupid i had protection for
workbook turned on.

ok... another stupid one for you...
why sometimes do my letters go behind the next cell which i prefer them
not and other times it goes over it ?


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=510927


Max

stuck
 
"darkbearpooh1" wrote:
.. why sometimes do my letters go behind the next cell
which i prefer them not and other times it goes over it ?


If longish text in say, A1 appears to go "under" the adjacent B1,
that usually means B1 isn't empty.

We could either widen A1 (i.e. widen col A)
or format A1 to "Wrap Text"
(via: Format Cells)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---



Max

stuck
 
Or, just clear B1 with the Delete key,
if it's meant to be empty
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---



darkbearpooh1

stuck
 

awsome! thanks thats wierd though because it didn't look as if
anything apeared in the adjacent cell .. Thanks!


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=510927


Max

stuck
 
You're welcome !

If B1 were to contain say, white space(s) [via hitting the spacebar]
then these "entries" would not be visible
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"darkbearpooh1"
wrote in message
news:darkbearpooh1.230w1r_1139590526.4976@excelfor um-nospam.com...

awsome! thanks thats wierd though because it didn't look as if
anything apeared in the adjacent cell .. Thanks!





All times are GMT +1. The time now is 12:53 PM.

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