Tag Archives: table

Excel: forget about OFFSET and uses “TABLES”

In a recent post, I proposed defining names and using OFFSET to create a dynamic list. It was brought to my attention that with Excel 2007 and later, there’s a much easier way to create dynamic ranges: insert or define … Continue reading

Posted in Excel | Tagged , , , , | Leave a comment

Word : Insert a line above a Word table at the top of the page

I decided to post this because I’ve experienced the problem and it is very frustrating. I read this in TechRepublic and I think it is a good bullet proof work around. Method 1 [Ctrl] [Home], Enter Method 2, just in … Continue reading

Posted in Word | Tagged , , | Leave a comment