shortcut

Hi There. I have created an auto correct entry for entering degree C and degree F where degree is actually the degree symbol oof for degree F and ooc for degree C). But in order for it to work, it has to be a separate word. So I end up entering 20 oof and there is a space between 20 and the...

Hi Experts, I have a little problem, i think you may have a solution for me as always i got a solution from this forum. Here is the picture: I am trying to copy text from first Table Heading "FRUMENTO TENERO NAZ.LE (1)". When i try to copy only this table text the next table text also...

Does anyone know how to turn this off? I've tried disabling animations for win 8.1 through the control panel and graphics acceleration in Excel advanced options--neither are helping. The cascade of shortcut key leads is really screwing with my mind--it's like being punished for using keyboard...

Hi, I have a macro that looks into the cell formula for the reference to another excel file name and sheet name and opens it/activates the sheet name. When I run the macro via Alt-F8 run macros, it works as expected, but when I assign a Shortcut it does open the file but do not activate the...

Hello Everyone, I am very new about VBa and i really request your help. I have a macro stored a module at Personel workbook and i am using personel workbook as a hidden one. when i assign a shortcut below macro it is not working but whrn i am press F5 at VBA Editor it is working. Please help me...

Can you let me know how to change the font color of a individual active cell by using the ctrl key? I used this command before but I believe that it was built into a macro. Thanks.

When I start to type a formula Excel helpfully provides a dropdown list of matching functions. e.g. Type "=ave" in a cell and Excel provides : AVEDEV,AVERAGE,AVERAGEA,etc Is there a way to select an item from the list without touching the mouse? I can use the keyboard up/down arrows to...

I have an Excel sheet with lots of shortcuts in the first column. It's the entire shortcut, including the .lnk extension. What I need to do is to be able to parse out the string to make the shortcut human readable when I create the hyperlink. I'm saving the output as HTML for a user to open...

Hi All, I have added a few shortcuts to Excel (14.2.5) for Mac and they work during the current session but every time I completely close the session and start a new one, the newly assigned shortcuts are gone. I've tried assigning them when there is no open workbook but the Excel application is...

<tbody> Hello everyone, Copy and paste from cell below -- Excel or Access version: Excel 2010 Computer operating system: Windows 7 Sample data: No sample data Formula(s) right now: Not applicable Current result(s): I know that CTRL + " results in copy...

Hi Everyone, Apologies as i am sure the answer to this is in the forum somewhere but i cant seem to type in the right search to find it. I am setting up a very basic spreadsheet for logging details received from a telephone hotline. e.g. recording people names, location, and some commentry...

Hey there, I was hoping someone could help me find a shortcut for cutting the parentheses value from a row of cells. The cells in my row each have a percentage and confidence interval value in parentheses and I would like to cut out the confidence interval. I have about sixty columns to work...

I have some hyperlinks in Excel documents which link to Shortcuts of files I created in a different folder. Some of them are not working any longer...Excel just spins when I click on them. Any ideas?

I've got an opportunity where I need to take a logfile (output from a powershell script), where I am logging a filename (full), target & working directory folders, etc. The Powershell script recursively searches a file folder for shortcut files (.lnk), and then changes info on the Target (to a...

Hello, How do you select a set of data that is thousands of rows but has blank cells interspersed with cells with data? For example, lets say I have data in A2:A3000 but I only have data in ever 10 cells (e.g. data in A2, A12, A22, etc.). How would I quickly select all of this data? I know...

Hi, This problem seems stupid but I really in trouble and need your help. Currently, I used Windows 7 with Microsoft Excel 2010 in Lenovo Thinkpad laptop. I notice that I cannot use an Excel keyboard shortcut to add row, delete row and other shortcut i.e. remove border Normally, I used...

Hi I don't tend to post to forums since the oracle (Google) tends to answer most of my questions, but this one I have been wondering about for some years. I love shortcut keys and hate the mouse. I therefore managed to configure my Excel such that I can do pretty much anything with the keyboard...

Here's how I've implemented a macro shortcut that will enable you to paste values only, even if it's from an outside application! Sub pasteValuesOnly() ' ' Keyboard Shortcut: Ctrl+Shift+V ' This allows the macro to pass on to ' the next method if it's text from outside of Excel On...

I am constantly selecting column(s) and formatting cells to the same thing: number no decimal place check thousand seperator Is there some kind of shortcut that I could be using? Thanks

Hey There... Okay, so I have tried everything that I and my IT guy that find... it still wont work, so maybe one of you have an idea. I have been working on a number of macros on a number of workbooks. I have created the Macros, and would like to create a shortcut button along the Customizable...