Excel Tricks-Moving to next line with in the cell

Here are some Excel tricks for easier work.

1: Selecting a row
press ‘SHIFT’ + ‘SPACE’. A row will be selected.

2: Selecting a column
press ‘CTRL’+ ‘SPACE’. A column will be selected.

3: Removing hyperlinks
select the cell + Right Click -> select Remove Hyperlink.

Removing Hyperlink in Excel

Removing Hyperlink in Excel

4: Wrapping the text with in the cell
select the cells +Right click + Format Cells +Under Alignment tab +Check Wrap text +Click ‘OK’.
the text will be adjusted with in the cell. If the text is too long then the hieght of the cell will be increased to wrap the content.

After Wrapping text

After Wrapping text

5:Shrinking the text with in the cell
In case if you don’t want the height of the cell to incease and fit the text with in the cell then follow these steps:
Select the cell + Right click + Format cells + Under Alignment tab+Check Shrink to fit+ Click ‘OK’

After shrinking text

After shrinking text

6:Add text in the cell in the next line
Enter the text in the cell then press ‘Alt’+’Enter’. The cursor will move to the next line.

Adding text in the next line with in the cell

Adding text in the next line with in the cell

Locations of visitors to this page

About these ads

9 Responses to “Excel Tricks-Moving to next line with in the cell”


  1. 1 How I Lost Thirty Pounds in Thirty Days May 4, 2009 at 9:07 am

    Hi, good post. I have been wondering about this topic,so thanks for writing. I will certainly be subscribing to your blog.

  2. 4 With This Diet I Was Able to Lose Thirty PĆ³unds in Only a Month May 6, 2009 at 4:36 am

    Hi, nice post. I have been thinking about this issue,so thanks for posting. I will probably be coming back to your site. Keep up great writing

  3. 6 synapticsuccess January 4, 2013 at 11:40 am

    God bless you for posting this. I have been fighting the the Number 5 suggestion for decades! Very helpful!

  4. 7 waist to hip ratio calculator April 6, 2013 at 9:00 am

    Thanks for sharing your thoughts. I really appreciate your efforts
    and I am waiting for your further post thanks once again.

  5. 8 ru April 11, 2013 at 3:44 pm

    Asking questions are genuinely good thing if you are not understanding something fully, however this post gives fastidious understanding even.

  6. 9 Fanny April 16, 2013 at 1:59 am

    Good day! Would you mind if I share your blog with my facebook group?
    There’s a lot of people that I think would really appreciate your content. Please let me know. Thank you


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





Follow

Get every new post delivered to your Inbox.

%d bloggers like this: