Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 42862 times)

Online Baruch

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2013
  • Posts: 2450
  • Total likes: 53
  • DansDeals.com Hat Tips 1
    • View Profile
Excel Help and Problems
« on: December 11, 2013, 03:34:07 PM »
The left side vertical numbers sometimes partially disappear. Like from 1-5 or 1-9. I play around and click and they reappear. What's going on? How do you make them reappear?
« Last Edit: July 20, 2017, 03:36:06 PM by jj1000 »
When somebody thanks you for a favor you've done, respond "my pleasure", not "no problem".

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 30
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #1 on: December 11, 2013, 03:37:15 PM »
Probably you click on the 'hide' and 'unhide' option.

Online Baruch

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2013
  • Posts: 2450
  • Total likes: 53
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #2 on: December 11, 2013, 03:43:11 PM »
Probably you click on the 'hide' and 'unhide' option.
where is that option?
When somebody thanks you for a favor you've done, respond "my pleasure", not "no problem".

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 30
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #3 on: December 11, 2013, 03:48:02 PM »
It's between the options that come up when you right-click on the vertical numbers.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6509
  • Total likes: 77
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #4 on: December 11, 2013, 03:52:07 PM »
Try shift alt left

Online Baruch

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2013
  • Posts: 2450
  • Total likes: 53
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #5 on: December 11, 2013, 03:52:52 PM »
Try shift alt left
I know what shift alt is. But what's left?
When somebody thanks you for a favor you've done, respond "my pleasure", not "no problem".

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 30
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #6 on: December 11, 2013, 03:54:46 PM »
Left arrow

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6509
  • Total likes: 77
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #7 on: December 11, 2013, 03:55:04 PM »
Not the shema hand.

This is to ungroup rows. This might be your issue. The rows should be selected when doing the combo.

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 30
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #8 on: December 11, 2013, 03:55:32 PM »
Try shift alt left
Do you think that it's a grouping issue?

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 30
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #9 on: December 11, 2013, 03:58:04 PM »
If it's a grouping issue then it should have the + or - sign.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6509
  • Total likes: 77
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #10 on: December 11, 2013, 03:59:52 PM »
to unhide ctr shift 9

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 30
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Problem
« Reply #11 on: December 11, 2013, 04:01:08 PM »
ctr-shift-9

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 6509
  • Total likes: 77
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #12 on: December 11, 2013, 04:01:51 PM »

Offline alpicone

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Aug 2012
  • Posts: 873
  • Total likes: 0
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #13 on: December 11, 2013, 04:15:56 PM »
When there are rows hidden there is a slightly thicker line between the rows. See the two screenshots which show the hidden rows and unhidden rows. On top of the 6 there is a slightly thicker line or between 4 & 7.

Offline HowYaDoin

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Jan 2013
  • Posts: 857
  • Total likes: 8
  • DansDeals.com Hat Tips 1
    • View Profile
Re: Excel Problem
« Reply #14 on: December 11, 2013, 04:50:41 PM »
GIYF for all excel shailos its already been asked and answered