Interesting Excel's twists

[Sektor]

Today I have discovered two interesting twists in Excel according to moving and repositioning cells. Here's workbook with description.

 

[RoryA]

If you mean Ctrl+Shift, that doesn't work for me?

 

[GlennUK]

It works for me ... for example, I've just done:
Select column B
Click on selection border
Hold down Shift
Then also hold down Ctrl
Drag border to new location, say between E and F ( target pointer is a grey single line that points between columns, and a small "+" sign appears next to the mouse ) ... and let go. It copies and inserts the column.

 

[RoryA]

Oh, I see - I was talking about option 1, not option 2. Can't get the insert cells to do a copy at the same time.

 

[PANKAJUTEKAR]

Today I have discovered two interesting twists in Excel according to moving and repositioning cells. Here's workbook with description.

========

Sektor Sir,

Thank You. This is really great. Even i am using.

 

[Sektor]

Glad for you!
Here's one more tweak. It's well known that to get thousand separator, you need to enter number, say, 123456789, then go to Format -> Number tab -> Number and tick "Use 1000 separator".
Here's very quick way: just enter 123 456 789 (with spaces).

 

[Domski]

That just enters a text string 123 456 789 for me.

Dom

 

[GlennUK]

That just enters string for me too. Entering as 123,456,789 automatically sets the number format as comma thousand separator.

 

[Sektor]

We have space as thousands separator in Russia. If I'd enter 123456789, I'd get 123456789 and then I had to go to Format. To avoid this, I add space.

 

[Gerald Higgins]

So it looks like, entering a number with the appropriate thousands separator for your location automatically formats the cell to display the thousands separator.

This type of thing also applies to some other number formats. For example, if I type
01/02/03
Excel automatically formats this as a date.

And if I type
01:02:03
Excel automatically formats this as a time.

Regional variations on the symbols may apply.

 

[Sektor]

Here's interesting twist I have recently found.

1. Select, say, C3:G10 range. Active cell is now C3.
2. Press Shift+↑ or Shift+↓: you see that only BOTTOM border is resized.
3. Restore original selection C3:G10.
4. Now make C10 active cell (thru Tab or Shift+Tab).
5. Press Shift+↑ or Shift+↓: you see that only TOP border is resized.
6. And if you select any cell between those "border" cells (C4:G9) and will press Shift+↑ or Shift+↓, you will see that if you press ↑, then top border is resized, and if you press ↓, only bottom border is resized.

The same thing for left and right borders of selection.