Excel Help....please
Cullen
Registered Posts: 592 Epic contributor ๐
I don't know what I have done, but I am sure it's me.
You know at the bottom of an excel spread sheet there is a bar and if you highlight a few cells SUM= appears and shows the total value of the cells?
Well my whole bar has disappeared and I want it back! Apart from paying a ransom, has anyone got any ideas?
You know at the bottom of an excel spread sheet there is a bar and if you highlight a few cells SUM= appears and shows the total value of the cells?
Well my whole bar has disappeared and I want it back! Apart from paying a ransom, has anyone got any ideas?
0
Comments
-
Click on View then status bar0
-
God, you are good!!!!0
-
Thanks lol.0
-
Did you also know that if you right click on the status bar you can also change the info it displays such as count, average, sum etc? You probably did but 'sum' still don't...0
-
-
Robert
Has the weather got to you? Making jokes! Stalking people on Facebook? Perhaps you'll even befriend me, again?0 -
Well bless my soul - I never knew I had a status bar - LOL - Thanks Cullen :thumbup:
Had no idea what you were talking about but I have now - You learn something new every day - Have been using excel for years but guess I have only ever scratched rhe surface of it
Maybe I should do a course ? ? . ..............0 -
Yes a course!
I'm going to learn all about painting in watercolours.
Useless to improve my excel skills, but very therapeutic............0 -
speaking about comps .anyone know how to change a PDF file back into a full jpeg file .....the pdf file has jpeg and words in it ,.so need the whole lot back into one complete jpeg picture ?0
-
Can't you just scan it as a jpeg, Mark, or have you tried that already? What exactly are you trying to do with it that you need it as an image?0
-
-
cheer .will give it ago....0
-
There are some big words in there Mark, will you cope okay?0
-
-
It's alright Mark - you only need to read them, you don't have to come on here and prove you can spell them afterwards!
:001_tt2:0 -
You would lose picture quality saving as a JPEG from PNG or BMP if you opened in Paint to save as JPG/JPEG. Just a thought.0
-
-
For anyone that was looking for excel training
http://office.microsoft.com/en-us/training/default.aspx
Seems a good place, have been recommended to have a look over it from my work, not had a chance yet tho..0 -
dont want training . just a little answer to smal questions ?0
-
Further excel issues.....
I have an excel hyperlink file which has links to the files I use a lot.
I was trying to put a password on a file, eventually succeeded and now if I have 2 excel files open, there is only one tab at the bottom of the screen. So when I close the file I was working on, the hyperlink file closes as well. This happens if I have 3 or 4 excel files open.
Secondly the worksheet tabs within the excel file have disappeared, so I can't move from one worksheet to another within the file.
What have I done? How do I fix it? Please help. Make it better. I don't like it when the man shouts at me, mummy........
(Look I always regress when under pressure. Everyone does it. I swear I saw Sandy Hood sucking his thumb once......)1 -
why don't you post your excel questions here
http://www.mrexcel.com/forum/forumdisplay.php?f=10
Excel experts are at hand to help you with any excel questions
good luck0 -
I was trying to put a password on a file, eventually succeeded and now if I have 2 excel files open, there is only one tab at the bottom of the screen. So when I close the file I was working on, the hyperlink file closes as well. This happens if I have 3 or 4 excel files open.
Do you mean two versions of Excel open simultaneously only showing as one open tab? If so and just a quick thought but has the 'Group Similar taskbar buttons' somehow become ticked? Right click anywhere on the bottom bar, go to properties, about fifth from top on the list (Windows XP)?0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership