Call us on 0844 800 7880
Tip of the Week

ms office 2016 logoMS Excel ~ Offset Command

DID YOU KNOW... that you can easily expand a named range of data automatically when you add a value to the range? 

If you add rows inside a range then the named range will extend to include these new entries. However, if you add a row at the bottom of the range the name will ignore it - here's how to get round that problem.

To find out more, click on a link below:

Click here for MS Excel 2016
Click here for MS Excel 2013
Click here for MS Excel 2010

 

We are no longer providing weekly tips for MS Office 2007 and 2003, but you can search for this lesson on your Dashboard if you are a member of that library.

If you are a member, just close this pop up window to go back to your Learning Dashboard.

If you'd like to become a member ...
and gain access to thousands of Bite Size lessons like these, please complete our contact form here.

If you'd like to receive our Weekly Tip emails every Tuesday ...
Just complete the green box on the right hand side of this page.

If there is a computer tip you'd like to see in the coming weeks ...
Let us know by completing our contact form here.

visit-our-shop

ms office 2016 logo
 

My Bite Size Login

On-line Courses
Facebook Twitter LinkedIn Google+ YouTube