![]() ![]() It should say we made 6 replacements as there were 6 formula’s in our range. I like to use # as it’s a character that’s unlikely to appear in any of the formula’s but you can use any text in front of the equal sign as long as it’s not in any of your formulas. This will turn any formula into a text string. In the Find what box type in = and in the Replace with box type in #=.Alternatively, you can use the Ctrl + H keyboard shortcut to open the Find and Replace window. Under the Editing section press the Find & Select button.Highlight the range you want to transpose.Replace any formula with text in the range which you want to transpose. In this post we’ll explore a work around method to get the same results as a cut and paste transpose would give (if it existed). One feature I’ve wanted is the ability to cut and paste transpose this can be handy as using copy and paste transpose won’t always result in formulas keeping the correct references. Regards, Bob J.Excel has some great features available in paste special, but where Excel is lacking is the ability to do any sort of cut and paste special. at least you can still assign a keystroke to them although the available combinations is extremely restricted :-) AI: Artificial Intelligence or Automated Idiocy? Please mark Yes/No as to whether a Reply answers your question. I'm not crazy about it either, but that's all there is unless you want to create a macro. of courseĪll of those methods involve use of the mouse/trackpad. Also, you can add the command to the QAT. Otherwise, use the ▼ on the right edge of the Paste button on the Home tab. The quickest method available is to use the Paste Options button that appears after pasting if the options include what you want. If you want to express your opinion to the design team, use the ☺︎ at the right end of the Excel Ribbon to submit feedback. ![]() Sorry, but in their infinite corporate wisdom Microsoft has deemed custom keyboard shortcuts in Excel to be a needless waste of space. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |