1. J

    Excel Keyboard shortcuts

    Hi Guys, I have office 365 insider. My question is that for Power Pivot the keyboard shortcut should be Alt + B + M. Instead I have to use Alt + Y4+ M. is there a setting I should do?? can I change the Keyboard Shortcut?? For me it is 1 key extra. Thanks for your help.
  2. M

    Change Cell Color

    Greetings, I am creating a spreadsheet, tracking my stock performance. I would like to have the cell color change automatically to red or green depending on whether the stock price went up or down. I am putting in an up or down arrow within the same cell as the stock price, using the Alt 24...
  3. V

    Excel Switch Between Workbooks

    Hi, Is it possible to get a macro to switch from current workbook, to previous workbook in code, similar to what 'Alt + Tab' does ? Thanks for any assistance !
  4. L

    quick way to do Go Special-->Column diff

    Hi I have long column which look like the one below. I want to go to next city fast, so I want to use Go to Special. I tried the following Ctrl + G then Alt + S then Alt +m Ok I can go to next city but how about going to next city, if i repeat all steps above that is slow? I was thinking I...
  5. I

    Are there any differences between these two ways of typing a shortcut?

    Hi guys, If I want to paste something as value, I can press Alt + ESV. That is, hold Alt and press and release e, press and release s, press and release v. It did the trick. However, I just found I can also press Alt and release it, press and release e, press and release s, press and release v...
  6. Dr. Demento

    User assigned keyboard shortcuts (ALT) not working

    I am having issues getting keyboard shortcuts with ALT to work and I'm wondering if I'm doing something wrong. The CTRL+SHIFT shortcuts work fine; however, in order to minimize re-assigning native CTRL shortcuts that I normally use, I've moved on to using ALT. However, they don't function at...
  7. B

    Import data from a scripted web page

    The script of the site I tried to retrieve data is as follows; *********>Top (10)Alt (10)Right (10)Left (10) Page Top comes with the selected way. I want the page to come with Alt, Right, or Left selected, and I want to import all the page content to cell A1 in "Full HTML Format".</div>
  8. L

    changing the text of Form Control objects

    Hi, I am trying to inset Developer-->Insert-->Contol Form-->Checkbox, into my excel. I can insert no problem, but I have problem with changing the default text of these control. I right clicked on the Checkbox, then right click-->format control--> Alt text, then I entered the new text there and...
  9. O

    "/" become quick access help me

    so when ever i type / it show up like this , i think it supposed to be alt function but in my excel when ever i type "/" it pops up help me
  10. S

    Name Mismatch

    Hi all just a quick question as my google not pulling up the right answers and dont fancy making half my database again. I'm having a naming issue on my database where when I've renamed a table its kept its original name as an alt name! how do you change this I cant see any options for it at...
  11. F

    Alt Enter for Careg Return

    I am using the following formula. ="Beginning Balance "&TEXT(AE10,"$#,##0")&" Capital Account Estimated Balance " I want it to show up in the cell on two lines. Like ALT ENTER does. I want the " Capital Account Estimated Balance " on the second line.
  12. L

    Automate IE Or Chrome With Sendkeys?

    Hi, I have a list of data, for short's sake A1:A10, what I've been previously doing is the following combination, CTRL C, ALT TAB, CTRL V, ALT TAB, DOWN ARROW, CTRL C, ALT TAB, CTRL T, CTRL V, ALT TAB, DOWN ARROW, CTRL C, ALT TAB, CTRL T, CTRL V.. this can go on for over 100 rows which is quite...
  13. J

    For my own education . .. ALT D E F to change numbers stored as text to numbers

    I understand that using ALT DEF changes "numbers stored as text" to numbers, which i do use almost daily . . . . but I just want to know WHY that works . . . . THoughts please?
  14. K

    Index/Match with Multiple Criteria

    Hello, Looking for some help would would save lots of time and manual labor. It is a basic index match with 3 criteria; as well as obtaining the MAX value of the index. So; the raw data looks like such. <tbody> SHEET 1 A B C D E 1 Group Business Control Risk1 Risk2 2 ABC...
  15. B

    Paste data from one spreadsheet into another after matches are found

    I thought I had my answer with index match, but it doesn't seem to work for me. I have two spreadsheets, one with only unique data. The other one has repetitive data. I would like to paste data from Sheet 1, to a column in Sheet 2, when matches are found. In my example below, the columns that...
  16. B

    Convert Rows to Columns

    I thought someone would have asked this, and they may have, but I was not successful in finding the answer in Excel. I have a large spreadsheet in rows that I would like to copy and convert to columns. Example of what I have: <colgroup><col width="64" span="4" style="width:48pt">...
  17. A

    Alt shortcuts in 'Open' Backstage don't work properly

    By default, when in the 'Open' Backstage, pressing Alt overlays shortcuts over buttons. In particular, '1', '2', '3'... are overlaid on the 1st, 2nd, 3rd... most recent workbook. Somehow (I think related to the 'Advanced>Display>Quickly access this number of Recent Workbooks' option, which I...
  18. B

    Need help parsing ALT+ENTER entries from a single cell in MS Excel 2010

    Greetings,<o:p></o:p> <o:p> </o:p> I'm exporting data from a Rational database application into an Excel 2010 spreadsheet. I need to parse the data in a way that will group the data by object ID (XX-YY-25xx). <o:p></o:p> <o:p> </o:p><o:p></o:p> <o:p>...
  19. B

    Word - Paste Options

    Is there a way to move focus to the paste options box that comes up (after pasting something) so I can select "keep source formatting", "match destination formatting", or "keep text only" with keystrokes, instead of using the mouse?
  20. P

    Use of sendkeys in excel with ALT Key

    Hi I am trying to use a macro to automate the use of alt key. my code looks like this--> Private Sub CommandButton1_Click() For i = 0 To 10 Range("A" & i).Value = ActiveSheet.SendKeys("%" & i) Next i End Sub This code is to enter the value of ALT+1...ALT+10 to column A Plz help..

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
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 "".
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