a100

  1. L

    selecting cells short cut

    Hi I want to select let say 100 cells A1:A100. I can do that using mouse but I wonder of I can select A1 and then go to A100 and they are all selected. I select A1 and I can go to A100 using F5 and type A100 but that would jump to A100 without highlighting the range A1:A100. Thank you.
  2. T

    Parent Child hierarchical format using Level

    Hi, I am trying to establish below in hierarchical format. Is there anyway if we can achieve output as below. tried grouping but didn't work. Input <colgroup><col width="64" style="width:48pt" span="3"> </colgroup><tbody> Node Level A100 1 101 Child 1 2...
  3. J

    First and Last?

    Hi All, I have a table showing contents, by serial #, in numbered storage boxes, which increase daily Example. Each box could have different quantities <tbody> Serial# Box# Comments A100 Box 001 Photos A101 Box 001 A102 Box 001 B100 Box 002 Documents B101 Box 002 B102 Box 002...
  4. O

    Excel Formula Help. Help on formula if any value from a2 to a99 equals a value from b2 to b99 then c must = a1

    Help on formula if any value from a2 to a99 equals a value from b2 to b99 then c must = a1 (I would enter the formula on a100)

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top