Two tips for faster worksheet navigation

re: Two tips for faster worksheet navigation

Kumaresan0506 — Thu, 29 Dec 2011 13:25:47 GMT

Great . Useful tips.

re: Two tips for faster worksheet navigation

Anneliese Wirth — Thu, 08 Dec 2011 19:14:19 GMT

HI Mantyvdas.

Thanks for giving us a bit more information about the scenarios that are causing you trouble. I will definitely pass on your comments to the product team.

- Anneliese

re: Two tips for faster worksheet navigation

Mantvydas — Tue, 06 Dec 2011 22:35:34 GMT

Thank you all for all the tips. They're nice. But really, they're all hard to use workarounds. I just don't understand that you never ever experience this difficulty yourself? And don't you want it to become very simple & easy?

In my Windows 7, I quickly dock one Excel instance to the left side (you know that Aero thing, that easily occupies half the screen), and then dock another Excel instance to the right side, and then I see both Excel files at one time, and then I expect to copy formulas with an ease. Dear Annaliese, don't you think that would be a perfect feature for Excel 2014?

And even more: sometimes I get two monitors, especially when I'm doing budgets. I fullscreen a target Excel on one monitor, and then fullscreen a source Excel on the other, and then copy things over. Oh, how I wish formulas would copy over. Try doing that in an MDI environment, resizing is overkill.

Cheers.

re: Two tips for faster worksheet navigation

Anneliese Wirth — Wed, 30 Nov 2011 20:27:37 GMT

Good point!

re: Two tips for faster worksheet navigation

Anneliese Wirth — Wed, 30 Nov 2011 20:18:02 GMT

Thanks for the tip, fzz!

re: Two tips for faster worksheet navigation

Amer07306 — Tue, 29 Nov 2011 21:16:48 GMT

there is an easy way...

Press Ctrl+~ (dont press shift, it's the "cigma" icon you need). it will expand entire sheet to show entire formula. then either add the "apostrophes before =" , OR use the Find/Replace option to look for "=" and replace with "apostrophes =".now you are ready to paste the formula into destination sheet. I would use find/replace option again and remove the apostrophes.

hopefully it will work.

re: Two tips for faster worksheet navigation

Anneliese Wirth — Fri, 11 Nov 2011 18:38:53 GMT

Nate, thanks for helping out with the VBA questions!

re: Two tips for faster worksheet navigation

Anneliese Wirth — Fri, 11 Nov 2011 18:23:45 GMT

Hi Mantyvdas. I'm glad you shared this here. I'm always interested in knowing where people are running into trouble. It sounds like you're working with multiple instances of Excel--is that right? Unfortunately, you can’t copy formulas between instances…they resolve into the target workbook as the value only. A workaround is to convert formulas to text by inserting an apostrophe before the = sign, copy and paste them in as text, then remove the leading apostrophe in Edit mode and press Enter.

re: Two tips for faster worksheet navigation

Mantvydas — Fri, 11 Nov 2011 11:33:16 GMT

I'm now working with multiple Excels... And I just hate that I can't open multiple windows of Excel, and copy paste formulas between them. So I decided to share my pain here.

re: Two tips for faster worksheet navigation

Anneliese Wirth — Mon, 24 Oct 2011 17:53:25 GMT

Hey everyone: Great discussion. Thanks a million for sharing your tips, ideas, and code!