johnime:
How do you freeze the third row or fifth column?

Good Morning

To freeze Row 4

1. Click on 5 on the row number
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes

DONE

To Freeze Column 5

1. Click on F to highlight column 6
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes

DONE

If you want to freeze both (Row 4 & Column 5) at a time

1. Click on cell F5 to highlight the cell
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes


You're done

Thank I will try it out

Raymonbell:


Good Morning

To freeze Row 4

1. Click on 5 on the row number
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes

DONE

To Freeze Column 5

1. Click on F to highlight column 6
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes

DONE

If you want to freeze both (Row 4 & Column 5) at a time

1. Click on cell F5 to highlight the cell
2. Click on VIEW on the ribbon
3. Under the WINDOW GROUP look for freeze pane
4. Click on Freeze Panes


You're done

johnime:
Thank I will try it out

You're welcome

Good job bro!

Please how do change sentences from capital letters to small letters or vice versa

jasmine1:
Good job bro!

Please how do change sentences from capital letters to small letters or vice versa

Thank you, Boss

You'll need excel functions to achieve that.

To change all text to capital letter


1. Select an empty cell (e.g Cell B1)
2. Type =Upper(A1) into cell B1.
I assumed you're changing text in cell A1. If not, change the A1 to the cell you want to change its case
3. If you want to change entire column just drag the first

To change all text to lower case


1. Select an empty cell (e.g Cell B1)
2. Type =lower(A1) into cell B1.
I assumed you're changing text in cell A1. If not, change the A1 to the cell you want to change its case
3. If you want to change entire column just drag the first

To change the first alphabet to upper case ( Sentence case)

1. Select an empty cell (e.g Cell B1)
2. Type =Proper(A1) into cell B1.
I assumed you're changing text in cell A1. If not, change the A1 to the cell you want to change its case
3. If you want to change entire column just drag the first


I hope this help

Note:

=lower(A1) to change all alphabet to lower case

=upper(A1) to change all alphabet to capital letter

=proper(A1) to change all alphabet to sentence case


I'm using A1 as reference change it to the cell you want to affect in your worksheet

Thanks gidi gaan!

jasmine1:
Thanks gidi gaan!

You're welcome

Cc

Mod

Raymonbell:
Mod

Kindly push this thread to FrontPage or other forums for others to benefit and learn something new


Cc
crazyMan
1forall

Good Morning


We are still here


Regards

This is cool.... Nice one broh.

TES2LA:
This is cool.... Nice one broh.

Thanks Man


Kindly Join me in keeping the thread alive

Still here
Anybody around

Wtf happened to this thread.

johnime:
Wtf happened to this thread.

Alive and alive

Good morning, Raymonbell

Thumbs up for the tutorials, really grateful. More knowledge, boss.

asocubed:
Good morning, Raymonbell

Thumbs up for the tutorials, really grateful. More knowledge, boss.

You're welcome Boss

Keep them coming.

[quote][/quote]

How do add the number in Cell 1, 5,8,12 without doing autosum?

Good evening bro, really admire ur effort in keeping this threat alive I will like if I can get tutorial manual on Excel 2007 am a beginner trying to have knowledge on Excel. Thumbs up to u sir

johnime:
How do add the number in Cell 1, 5,8,12 without doing autosum?

Are you referring to an entire row?

if not, you need to be specific with your cell address

nurukool:
Good evening bro, really admire ur effort in keeping this threat alive I will like if I can get tutorial manual on Excel 2007 am a beginner trying to have knowledge on Excel. Thumbs up to u sir

Sorry I'm responding late I have been very busy this days

First, I will suggest you get Excel 2013

I will share some links with you later today


Cheers

nurukool:
Good evening bro, really admire ur effort in keeping this threat alive I will like if I can get tutorial manual on Excel 2007 am a beginner trying to have knowledge on Excel. Thumbs up to u sir

Here is the video tutorial like I promised.

https://www.youtube.com/playlist?list=PLiMtZPx84E9mfoqEcHOXjgdrwEpmeD4xG

You can watch directly on YouTube or download to your computer
I will encourage you to download the videos for easy referencing anytime

Use this website to download playlist easily
http://megavn.com/
Copy the link of the YouTube playlist and insert it into the search box on Megavn

I will be here to answer any of your question and help with your challenges but ensure you quote or mention my username for me to notice your question easily

If you’re on tight budget try MTN night browsing.
MTN night and weekend browsing did the magic for me when I was a beginner

Hello here, I stumbled upon this educative right on time. Pls, how do i get started in learning excel and powerpoint?

Please what is the code for the MTN night browsing?