[@marycain5232]

I thought I knew enough Excel, but with each video I watch I find out some great tools to use to make my spread sheets better

[@sunilsingh10]

Wonderful stuff

[@nonoobott8602]

Great tips. Thanks so much

[@wayneedmondson1065]

Hi Jon.. thanks for the great tips.. all useful and helpful for being productive. Thanks for compiling them all in one place. Thumbs up!

[@ExcelCampus]

Thank Wayne! 🙂👍

[@ARUNKUMAR-yz8uq]

Your all videos are good sr

[@ExcelCampus]

Thanks Arun! 🙂

[@dlsgl407]

Thank you for this video!

[@roderickmose4691]

Thoroughly enjoyed this John! Thanks for another clearly explained and useful video.

[@ExcelCampus]

Thanks Roderick! 🙂

[@bestscenes1469]

Great Video. I love the evaluate feature.

[@ExcelCampus]

Thanks Daniel! 🙂

[@farithahamed3599]

Thanks John for the insights

[@ExcelCampus]

Thanks Farith! 🙂

[@kathyrusinski8653]

Really helpful! Thank you !

[@abdullahibrahim1573]

Well done! That's what called useful video

[@ExcelCampus]

Thanks Abdullah! 🙂

[@torque6389]

Great video

[@ExcelCampus]

Thanks Tevin! 🙂

[@reneanaje2050]

So useful. What would I have done without you?

[@ExcelCampus]

Thanks Rene! I really appreciate your support. 🙂

[@katerina6495]

Great John, that it is a very helpful video, thank you so much

[@ExcelCampus]

Thanks Katerina! 🙂

[@smith28c]

Great tips Jon,
I am a Mac user, is it possible to include the equivalent key functions in your videos, I am sure there are lots of Mac users that have the same problem.
Cheers,
Don

[@ExcelCampus]

Thanks Don! I believe these function key shortcuts should work on the latest Mac version.

[@darkseid5381]

Please make video about IF function...

[@puneetvij8433]

John Sir,
An important one! ; )

[@ExcelCampus]

Thanks Puneet! 🙂

[@drsteele4749]

Good video, Jon. Don't you find it annoying that pressing Enter moves the cursor down one cell? I put a stop to that decades ago by adjusting the setting in File|Options.

[@marksilva5377]

Where does the cursor go after hitting Enter? Does it stay in place?

[@joem112]

Instead of pressing enter and driving the cursor down one row, press CONTROL+enter, the cursor will stay in the same cell.

[@ExcelCampus]

Thanks DRSteele! I think it all depends on the task at hand. When writing and editing formulas then it can definitely be annoying. As Joe mentioned, Ctrl+Enter is a good way to keep the selection on the cell. When doing data entry type tasks then Enter can be very useful to move down to the next cell.
Thanks again for bringing this up. I'll do a video on it in the future.

[@drsteele4749]

@@ExcelCampus Thanks Jon. But data entry to the next cell (be it up, down, left right) can be always achieved by typing the data and then using the appropriate arrow key on the keypad to invoke and then move. Keeping the Enter key as 'do not move' is my preference.

[@marksilva5377]

Does being in Lotus mode in Options, change the usability of these function keys you just showed?

[@ExcelCampus]

Great question Mark! I don't use Lotus mode so I'm not 100% sure, but I'd definitely recommend testing them out.

[@behnamebrahimi1625]

👍👍👍👌👌👌

[@Tat-cx1lr]

Bonjour, J’ai un tableau Excel avec une colonne « Période » dans laquelle il y’a les mois et l’année 2019. J’ai mis les mois en format mois et l’année 2019 en format standard. Le problème est que mon Tcd me donne toute la colonne période en format numérique. Pourriez-vous m’aider à résoudre ce problème svp. Merci d’avance. Amicalement.

[@rickkeev4919]

Ctl Z gets you out without keeping the F9 edit too.

[@ricos1497]

Yes! I came here to say just that. It took me a while to realise it too (think I saw it in another video). Much more useful if you've evaluated a couple of steps within the formula.

[@ExcelCampus]

Great point! Thanks Rick & Rico! 🙂👍

[@nononsense129]

For me Tip#1 doesn't work as expected!! instead it works as if I pressed Enter Key. I tried several times.

[@ExcelCampus]

Sorry to hear that. It could be that F3 is a multi-use key on your keyboard and you might need to press Fn in combination.