Tag Info

New answers tagged

1

I figured it out - it was because I was running Visual Studio as an admin but not the Macro recording program -


0

An entirely different approach to get selected pages printed exists in Office, LibreOffice and most likely any other variant of these. CTRL+P opens the Print dialog. Find the "(o) Pages" radio button, click it, then type the page numbers in the box beside it; as in: -2, 5-10, 17, 18, 20- or similar. By that you do not need to include special macros, and ...


-1

You can close Excel using ALT F4 - this will close Excel completely


0

=IF(OFFSET('Sheet 1'!$A$1,MATCH('Sheet 2'!A1,'Sheet 1'!$A:$A,0)-1,1)<>"",OFFSET('Sheet 1'!$A$1,MATCH('Sheet 2'!A1,'Sheet 1'!$A:$A,0)-1,1),OFFSET('Sheet 1'!$A$1,MATCH('Sheet 2'!A1,'Sheet 1'!$A:$A,0)-1,1)) What you requested for the unfound values is the same you requested for found values, if you really want to fiddle around with shifting based on ...


0

Select cells you want to move. Now try to move them by drag n drop to different worksheet (different tab). I know, it scrolls. Here is the tricky part: just press cmd (mac) or alt (win) and it will let you drop the cells to another tab.


1

As Daniel mentioned, MySQL For Excel add-in is causing this issue. Disabling it and restarting Excel fixed this issue and saves without the nagging dialog.


0

Autohotkey as suggested by James is better for automation of simple key entries. If these strings are always the same it's easy this way, the script can also be compiled into an executable and when neede, all you need to do is to run it or enact the hotkey event. The other option, in my opinion is the better one, is the password safe KeePass. It's open ...


0

There are multiple options that don't exactly insert text by a keyboard combination shortcut (like CMD+Q), but that 'expand' short blurbs into longer words/phrases/sentences that you define. (e.g OMW = On my way!) I historically used TextExpander on Mac, but now Mac has this capability built-in (in fact it was incredibly hard to type OMW above because it ...



Top 50 recent answers are included