two questions laptop freeze and excel

  Newuser2533 23:16 14 Sep 03

When my computer freezes I do Ctrl,Alt,Del and it always sorts itself. If it doesn't I have the option of switching it off at the mains.
When a laptop does the same thing, what are my options as after pressing Ctrl, Alt, Del it stays frozen for some time.
This happened to my daughter and she had to be back at college within five minutes.
I think what I'm saying also is ....can the laptop be left for 5 hours after it freezes without doing any damage.

I have just transcribed some of the 1841 census onto Excel and unfortunately have done 400 names in capitals when they should be in lower case.
Is there a way of changing the names into lower case all in one operation.

Sorry to be a complete pain.


  MAJ 00:46 15 Sep 03

Assuming all the names are in column A, right click on the top of column B and insert a new column. In the first cell of that new column enter the formula


then hit Return. Click back into the first cell with the lower case name. Now drag that formula using the little square at the bottom right of the cell, to the end of your names. You will notice that after you've hit Return again, the names will change to lower case. Now right click on the top of the column with the uppercase names and choose Hide.

If you have BILL

=LOWER(A1) will change it to bill

=PROPER(A1) will change it to Bill

=UPPER(A1) will change it back to BILL

Hope it helps a little, Newuser2533, as I know little about Laptops.

  fitshase 08:13 15 Sep 03

In answer to your first question, nothing will happen to the laptop and it will not stay on for 5 hours, the battery will be flat before that.

In fact, draining the battery will do the battery life the world of good.

However, if you want to switch the laptop off after it freezes, simply press and hold the power button. If that does not work (no reason why it shouldn't) then simply remove the power lead and let the battery discharge.



  Belatucadrus 09:40 15 Sep 03

Or remove the power lead and the battery, I've had to resort to this in the past.

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…