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 159680 times)

Offline Baruch

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jan 2013
  • Posts: 2638
  • Total likes: 218
  • DansDeals.com Hat Tips 2
    • 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 »

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 31
  • 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.

Offline Baruch

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jan 2013
  • Posts: 2638
  • Total likes: 218
  • DansDeals.com Hat Tips 2
    • 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?

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 31
  • 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: 7273
  • Total likes: 288
  • 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

Offline Baruch

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jan 2013
  • Posts: 2638
  • Total likes: 218
  • DansDeals.com Hat Tips 2
    • 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?

Offline Ches

  • Dansdeals Bronze Elite
  • *
  • Join Date: Nov 2011
  • Posts: 31
  • 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: 7273
  • Total likes: 288
  • 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: 31
  • 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: 31
  • 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: 7273
  • Total likes: 288
  • 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: 31
  • 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: 7273
  • Total likes: 288
  • 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: 881
  • Total likes: 2
  • 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: 875
  • Total likes: 9
  • 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

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #15 on: December 11, 2013, 05:44:38 PM »
If the were hidden they wouldn't "partially" disappear.

Offline alpicone

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Aug 2012
  • Posts: 881
  • Total likes: 2
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Excel Problem
« Reply #16 on: December 11, 2013, 07:12:02 PM »
If the were hidden they wouldn't "partially" disappear.

Row height then?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #17 on: December 11, 2013, 07:35:43 PM »

Offline AJK

  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • ********
  • Join Date: Jun 2011
  • Posts: 25465
  • Total likes: 444
  • DansDeals.com Hat Tips 15
  • Gender: Male
    • View Profile
  • Programs: United Concierge Key; Delta Global Services; American Chairman; US Airways 1K; Hilton Sapphire; Hyatt Tritium; Marriott Californium; Starwood Kryptonium; Hertz Plutonium; National Adamantium, Avis Executive Proactanium
Re: Excel Problem
« Reply #18 on: January 07, 2014, 02:08:25 AM »
Excel Experts:

What would the formula be if I wanted to search a particular sheet for the word "Cost" and then sum all the values in the cell immediately adjacent that "Cost" cell?

2015: 116K bkd | 1.6M brnd | F: OZ,NH,AA,EK | J: UA,CA,TK,DL,TN,AF,VA | LIH,NRT,ROR,PEK,CNS,BOB,MEL,TLV & Pacific Hopper

Offline lechaim2life

  • Dansdeals Gold Elite
  • ***
  • Join Date: Jul 2011
  • Posts: 151
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile