Excel 2007 Tutorial 25: Q&A

Excel 2007 Tutorial 25: Q&A. Replies and answers to previous comments and questions. Removing table formats, remove headers from tables, and removing passwords.
Video Tutorial Rating: 4 / 5

Don’t forget to check out our other video tutorials or share this video with a friend.

0 votes

Loading... 2,874 views

11 responses to “Excel 2007 Tutorial 25: Q&A”

1. 10minutetrain . says:

   19/03/2015 at 1:56 pm

   You could use an IF statement. For example, if you were subtracting Cell H9
   from G9 and the result was negative, it would leave a 0, otherwise it gives
   the value Example code =IF(G9-H9<0, 0,G9-H9)

   Reply
2. Robert Burns says:

   19/03/2015 at 2:05 pm

   How do I avoid a circular reference? I want to add A1 that I key in to what
   exists in B1 with the answer in B1 increasing by the amount in A1. i.e.
   keep a running total in B1.

   Reply
3. Zarin Alireza says:

   19/03/2015 at 2:33 pm

   Excellent

   Reply
4. Rashmi Sharma says:

   19/03/2015 at 2:43 pm

   rick You have been of a great help. keep posting such tutorials . you are
   helping millions across the globe

   Reply
5. Stephen Odiase says:

   19/03/2015 at 3:31 pm

   Thanks Rick, I have watched all 25 videos, you sure are a nice teacher.
   Many thanks. I have a question, please how do you get a cell to return zero
   instead of a negative number?

   Reply
6. TheGeeseey says:

   19/03/2015 at 3:50 pm

   thank you very much from UK

   Reply
7. ليث العامري says:

   19/03/2015 at 4:36 pm

   AWESOME WORK , THANKS SO MUCH!!

   Reply
8. faisal sheraz says:

   19/03/2015 at 5:09 pm

   great man.ur videos are helpful. pakistan zindabad

   Reply
9. zighag says:

   19/03/2015 at 5:48 pm

   Awesome! Excellent Teacher!

   Reply
10. micelamicela says:

    19/03/2015 at 6:33 pm

    How to make in column A that all students starts with big letter? Either
    some particular letter? 🙂

    Reply
11. meonly says:

    19/03/2015 at 6:53 pm

    From saudi arabia, thank you

    Reply