Categories
Planning

How to quickly move or copy content in word using f2

Today’s tip is a quick but useful one for Microsoft Word users. We’ve often discussed how keyboard shortcuts are the key to making you more efficient. But sometimes you can find new keyboard shortcuts that are even more efficient than the ones you were using before.

Today, we’re going to talk about one such set of shortcuts that make it just that little bit easier to cut/copy and paste text or images in Word. This works in Word 2007 through Word 2013.

Move to where?

To do a cut and paste without the hassle of the right-click or the ctrl+X, ctrl+V one-two punch, highlight the text or image you’d like to move and then hit the F2 key.

At the bottom left corner of the Word 2013 window, the program asks you “Move to where?” as you can see in the image below.

Shortcuts don’t get much simpler than F2. (Click to enlarge.)

Move your mouse to the point in the document you want to insert the text or image, click, and then hit Enter.

That’s it! Your selected text will be cut from where it was and pasted in the new spot.

Copy to where?

If you wanted to copy-and-paste your text or image, i.e. you want the same content to appear in two spots in your document, follow almost all of the same steps as above.

First select the text you want to copy, then hit shift + F2 and the phrase “Copy to where?” appears in the lower left corner of Word, as seen below.

Word’s shift + F2 is a simple way to copy and move text once. (Click to enlarge.)

Next, move your mouse to where you want to put the new copy, click, hit Enter, and you’re done.

One important note with both the F2 and shift + F2 shortcuts is that they only work once. This does not add the text or graphics to your clipboard for multiple paste jobs. Once you hit Enter that’s it short of undoing your last action with ctrl + Z.

Using F2 instead of the usual keyboard shortcuts may take some getting used to, but it is just that little bit more efficient (and easier to remember) than the typical ctrl + [C, X, V] keyboard shortcuts.

Hayley Milliman is a former Teach for America teacher turned curriculum developer and writer. Over the past five years, she’s written hundreds of articles on everything from Microsoft Office to education to history. She’s co-author of the book Museum Hack’s Guide to History’s Fiercest Females. Read more.

The function keys on keyboards don’t get the love they used to, but depending on the app you’re running, they can still be quite handy. Word, in particular, has some interesting features tucked away behind your function keys. Here’s what they do.

  • F1: Get help. How this works depends on what you’re looking at in the Word window. Press F1 in the regular document window, for example, to open Word’s Help pane. Sometimes, though, pressing F1 takes you to Microsoft’s support site and shows you more targeted articles about the feature you’re looking at. This is the case most of the time when you press F1 while a dialog box is open.
  • Shift+F1: Open Word’s “Reveal Formatting” pane, where you can see the character and paragraph formatting of whatever text you have selected.
  • Alt+F1: Jump to the next field if you’ve got fields in your document.
  • Alt+Shift+F1: Jumps to the previous field in your document.
  • F2: Move text or objects. Select the text or object you want to move and then hit F2. Place your insertion point where you’d like to move the item and then hit Enter.
  • Shift+F2: Copy selected text. It’s just like hitting Ctrl+C.
  • Ctrl+F2: Open the Print window, where you can preview and print your document.
  • Alt+Shift+F2: Save your document. If you haven’t saved your document previously, it opens the Save As window.
  • Alt+Ctrl+F2: Pop up the Open window so you can open a document.
  • F3: Expand an AutoText entry. Type at least the first four letters in the name of your AutoText entry and then press F3 to expand it to the full text.
  • Alt+F3: Create an AutoText entry from selected text.
  • Shift+F3: Change the case of selected text. Pressing this combo repeatedly cycles through the following case styles: Initial Letter Case, ALL CAPS CASE, and lower case.
  • Ctrl+F3: Cut selected text to the Spike. You can cut as much text as you want this way and it all accumulates on the Spike.
  • Ctrl+Shift+F3: Insert the contents of the Spike. Performing this action also clears any text in the Spike.
  • F4: Repeat your last action.
  • Shift+F4: Repeat the last “Find” action. This one’s handy because you can use it to browse search results without having the Find and Replace window or Navigation pane open.
  • Ctrl+F4: Close the current document. You’ll be asked to save the document if you’ve made any changes.
  • Alt+F4: Quit Microsoft Word. This closes all open documents (giving you the chance to save changes first) and exits Word.
  • F5: Open “Go To” tab on the Find and Replace window. You can use this to quickly jump to a page, section, bookmark, and so on.
  • Shift+F5: Jump the previous edit you made in your document. Press it again go one more edit back. Word remembers your last two edits. This works even after saving and closing a document, letting you return to where you left off when you open the document again.
  • Ctrl+Shift+F5: Open the Bookmark window so you can edit bookmarks. If your insertion point is in an existing bookmark, pressing this combo opens the Bookmark window and selects that bookmark.
  • F6: Go to the next pane or frame in your Word window. You can use this to navigate the window without using your mouse.
  • Shift+F6: Go to the previous pane or frame.
  • Ctrl+F6: Go to the next open document window.
  • Ctrl+Shift+F6: Go to the previous open document window.
  • F7: Open the Editor pane and start a spelling and grammar check.
  • Shift+F7: Open the thesaurus. If you have a word selected when you press this combo, Word opens the thesaurus and looks up the selected word.
  • Alt+F7: Find the next spelling or grammar error in your document.
  • Alt+Shift+F7: Open the Translation pane.
  • F8: Enter Word’s selection mode and expand a selection. While in this mode, you can use the arrow keys to extend your selection. You can also press F8 up to five times to extend the selection outward. The first press enters selection mode, the second press selects the word next to the insertion point, the third selects the whole sentence, the fourth all the characters in the paragraph, and the fifth the whole document.
  • Shift+F8: Reduce a selection. This works the same way as expanding a selection, but backward.
  • Ctrl+Shift+F8: Selects a column. Once the column is selected, you can use the left and right arrow keys to extend the selection to other columns.
  • F9: Update a field. This is the same as right-clicking a field and choosing the “Update Field” command.
  • Shift+F9: Reveal a field’s code.
  • Ctrl+F9: Insert new Empty Field <> braces.
  • Ctrl+Shift+F9: Unlink a field.
  • Alt+F9: Toggle the display of a field’s code.
  • F10: Show key tips. Pressing this combo reveals single letter shortcuts you can use to access Word’s menu commands.
  • Shift+F10: Display a context menu. This works just like right-clicking.
  • Ctrl+F10: Maximize document window.
  • Alt+Shift+F10: Display a menu or window for an available selection.
  • F11: Jump to the next field in your document.
  • Shift+F11: Jump to the previous field in your document.
  • Ctrl+F11: Lock a field so it cannot be edited.
  • Ctrl+Shift+F11: Unlock a field.
  • Alt+Shift+F11: Start the Microsoft Script Editor.
  • F12: Open the Save As window.
  • Shift+F12: Save your document.
  • Ctrl+F12: Open the Open window.
  • Ctrl+Shift+F12: Open the Print window.

Microsoft Word has loads of great keyboard shortcuts, and its support for the function keys on your keyboard is no exception.

Lori Kaufman is a technology expert with 25 years of experience. She’s been a senior technical writer, worked as a programmer, and has even run her own multi-location business. Read more.

There is a little known feature that has been available in Word since the DOS days. Suppose you want to move some content from one location in your Word document to another, but you want to preserve something else you copied onto the clipboard.

Rather than using “Ctrl + X” to cut (or “Ctrl + C” to copy) the information and then “Ctrl + V” to paste it, there are a couple of keyboard and mouse combinations that make it very quick and easy to do this.

First, highlight the content you want to move (this can contain elements such as text, images, and tables).

Leave the content highlighted and move to the location in your document to where you want to move or copy the text. Don’t click the location yet.

To move the text, press and hold the “Ctrl” key while you right-click where you want to paste the text. The text is moved to the new location.

If you would rather copy the text to the new location, and not remove it from its previous location, press and hold the “Shift” and “Ctrl” keys and then right-click in the location where you want to paste the text.

The benefit of this method is the clipboard is not used. So, if you had something on the clipboard before you copied or moved this text, it is still there for use later.

Copy Text Formatting in Microsoft Word using the Format Painter or Keyboard Shortcuts

by Avantix Learning Team | Updated April 14, 2022

Applies to: Microsoft ® Word ® 2013, 2016, 2019, 2021 or 365 (Windows)

In Microsoft Word, you can copy text formatting quickly and easily using the Format Painter or keyboard shortcuts. You can copy character formatting only (such as font, size, and bold) or both character and paragraph formatting which would include alignment, indents and line spacing. In Word, a paragraph is anything with a hard return after it.

Do you want to learn more about Microsoft Word? Check out our virtual classroom or in-person classroom Word courses >

To view hard returns or paragraph marks and other nonprinting characters in Microsoft Word:

  1. Click the Home tab in the Ribbon.
  2. Click Show/Hide ¶ in the Paragraph group. Paragraph marks, tabs, spacing and other nonprinting characters will display but will not print. Click the same command to hide the paragraph marks and other nonprinting symbols.

1. Copying text formatting using the Format Painter

The Format Painter is a great tool for copying formatting. It appears on the Home tab in the Ribbon in the Clipboard group:

To copy text formatting using the Format Painter:

  1. Select the text with the formatting you want to copy. Select characters only (such as a word or words) if you want to copy character formatting. Select an entire paragraph if you want to copy character and paragraph formatting.
  2. Click the Format Painter on the Home tab in the Ribbon in the Clipboard group. If you want to copy formatting to multiple instances of text, double-click the Format Painter.
  3. Drag over the text to which you want to copy the formatting. If you drag over characters only, Word will copy character formatting. If you drag over an entire paragraph or paragraphs, Word will copy character and paragraph formatting.
  4. Repeat if necessary by dragging over other text to which you want to copy formatting (if you had double-clicked the Format Painter).
  5. To turn off the Format Painter, press Esc.

2. Copying text formatting using keyboard shortcuts

To copy text formatting using keyboard shortcuts:

  1. Select the text with the formatting you want to copy. Select characters only (such as a word or words) if you want to copy character formatting. Select an entire paragraph if you want to copy character and paragraph formatting.
  2. Press Ctrl + Shift + C.
  3. Drag over the text to which you want to copy the formatting. If you drag over characters only, Word will copy character formatting. If you drag over an entire paragraph or paragraphs, Word will copy character and paragraph formatting.
  4. Press Ctrl + Shift + V.
  5. Repeat steps 3 and 4 for other instances of text.

3. Copying paragraph formatting only

To copy paragraph formatting only:

  1. Ensure that paragraph marks are displayed.
  2. Drag over the paragraph mark of the paragraph with the formatting you want to copy.
  3. Press Ctrl + C.
  4. Drag over the paragraph mark of the paragraph with the formatting you want to replace.
  5. Press Ctrl + V.
  6. Repeat steps 4 and 5 for other instances of text.

This article was first published on October 24, 2021 and has been updated for clarity and content.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

In Windows, you can assign cut, copy, and paste shortcuts to functions keys for ease of use. Here are the exact steps on how to do it.

To copy something from one place to another, we generally use the built-in Cut, Copy, and Paste functionality. For example, to copy a file, folder, or text, you can copy it and paste it into the destination. Almost every operating system has some sort of cut, copy, and paste functionality so that the user can move or copy data between places and applications. The default keyboard shortcuts for Cut, Copy, and Paste actions in Windows are “Ctrl + X,” “Ctrl + C,” and “Ctrl + V.”

For the most part, the default Cut, Copy, and Paste shortcuts are pretty easy to use, and the placement is not that hard on your fingers either. However, you can make it a bit easier by assigning Cut, Copy, and Paste shortcuts to the function keys. That way, you don’t have to press the shortcut to get the job done awkwardly. After all, the functions keys sit ideally, save but a few like F2, F5, and F11.

Assigning Cut, Copy, and Paste shortcuts to Function keys is very helpful if you are constantly moving or copying data. For example, if you are working on an Excel sheet, the ability to cut, copy, or paste with a single keypress will increase your productivity and experience significantly. The same is true for other use cases too.

In this quick and straightforward Windows guide, I will show you how to assign cut, copy, and paste shortcuts to function keys.

Assign Cut, Copy, and Paste Shortcuts to Function Keys

To assign cut, copy, and paste shortcuts to functions keys, we will use a free and open-source application called AutoHotKey. Using AutoHotKey, you can remap keys and create macros with ease. One of the best things about AutoHotKey is that it is lightweight but a pretty powerful application. Here is how to use AutoHotKey to assign Cut, Copy, and Paste shortcuts to function keys.

First, download and install AutoHotKey if you haven’t already.

After installing the AutoHotKey software, go to the desktop. Next, right-click on the desktop and select “New” and then “Text Document.” This action will create a new text file on your desktop.

Name the text file anything you want. Make sure you change the file extension from “.txt” to “.ahk.” For example, I named the file “CutCopyPaste.ahk.” If you cannot change the file extension, you might have to enable file extensions in Windows first.

Next, right-click on the newly created file and select the “Edit script” option. As soon as you choose the Edit Script option, the AHK file is opened in the Notepad. This is where we will add the script.

In the Notepad file, paste the below script. The script remaps the copy, paste, and cut shortcuts to F6, F7, and F8, respectively. If needed, you can change the function keys to the ones you want. For example, to use F8, F9, and F10 as the shortcuts, replace F6, F7, and F8 with them.

Next, click on “File” and then select “Save” to save the file. You can also press the “Ctrl + S” shortcut to save the script. After saving, close the Notepad.

Finally, double-click on the AHK file you just created. It will launch the script, and you can see it on the taskbar.

As long as the script is running, the Cut, Copy, and Paste shortcuts are mapped to the functions keys. That means you can press the appropriate function keys to perform Cut, Copy, and Paste actions.

To ensure the script is always running, I recommend you configure AutoHotKey to start with the system. That way, you don’t have to launch the script manually.

That is all. It is that simple to assign cut, copy, and paste shortcuts to function keys in Windows.

I hope that helps.

If you are stuck or need some help, comment below, and I will try to help as much as possible.

You may already know pressing [F5] key in Windows system can refresh the current page, and pressing [F11] can enable the full screen mode. But do you know the specific functions of all the keys from F1

They do have different functions in Windows system (like the desktop, system folders, browsers, etc.) and Microsoft Office Apps, but equally simple and practical. So, let me show you how to use F1-F12 keys to improve the working efficiency with computers.

It’s a help key works in all kinds of programs including Microsoft Office apps. The help information will pop out when you press [F1]. For instance, press [F1] in Word document will invoke the Help panel.

In windows system, it can rename your files. You can just click the file once and press [F2], then input the new name it and press [Enter] to confirm it.

But in Microsoft Word, it helps you to move selected text of images.

Select the specific text or image and press [F2], then place the cursor at another location and press [Enter] to move it. It’s a little like cutting and pasting.

This key is for searching in Windows. You can press [F3] in system folders, then the cursor will be located to the search box and you can type the key word directly.

And in Word document, pressing [F3] can invoke text from the AutoText Gallery. But before that, you should save the specific text into AutoText Gallery.

Select the text, click Quick Parts in Insert tab and click AutoTextSave Selection to AutoText Gallery. Don’t forget to set a memorable name for the text. Next time you want to quote it, just enter the name in the Word document and press [F3].

This key works in Internet Explorer. Pressing it after opening the browser, the pages you’ve visited will show under the address box. You don’t need to expand the drop-down menu to check the browse history.

It’s probably more powerful in Office apps such as Excel and Word. With [F4], you can repeat the last action you’ve done, which means you can redo an operation to multiple words or Excel cells. You can check the details in another post about using F4 in Word.

It should be one of the most used hotkeys in Windows. As you know, it can refresh the pages, especially web pages, no matter what kind of browser you are using.

And in Office, it has a different function. You can quickly call out the Go To window by pressing [F5] and choose a location in the document (or spreadsheet) to go.

It will locate your cursor to the address box, but won’t show the browse history. In addition to Internet Explorer, [F6] works well in browsers like Chrome and Firefox as well.

It can also help you switch between different parts in Microsoft Word. Press [F6], you’ll see numbers and letters show above these tabs and tools. Pressing a specific key will enable the corresponding function.

[F7] has no effect on system desktop but works well in command strings. It can directly invoke the command you’ve entered before, which is very useful for people who use command strings a lot.

Pressing [F7] in Word will run the spelling and grammar check on your current document to find your mistakes and give you advices to correct them.

In the process of starting up your computer, quickly press [F8] will enable the advanced menu. If there’s something wrong with your computer and you can’t boot it normally, you can press [F8] to enter the start menu, and choose safe mode or other options to start up the computer.

It’s also practical in Word. Normally when you want to select some specific paragraphs, you need to press and hold the left mouse, drag it to select the text. It’s not very convenient if the content you want to select is across two or even more pages. But with [F8], it’s much more easier.

Put the cursor before the content you want to select and press [F8] to active the function of expanding selection. Then you can scroll down and place the cursor at anywhere to mark the end of selected area.

There’s another way to make use of [F8]. Just press it twice, the word after the cursor will be selected; press it for the 3rd time, the first sentence after the cursor will be selected; press it for the 4th time, the current paragraph will be selected; press it for the 6th time, the whole document will be selected.

This is not a very commonly used hotkey. You can use it to send and receive emails, turn down the volume in the default player of Windows.

It can also refresh the specific field in Word. When you calculate the summation in Word tables, you are actually using field. As you know, there’s no such a feature in Word like Fill Handle in Excel which can apply the same formula to multiple cells correctly. But with [F9], you can enter the formula once, and copy the result to multiple cells, then select the text in each of cells and press [F9] to refresh them. You’ll see these results of calculation being corrected magically.

10. F10

If you use [F10] alone in Windows, it can basically only turn on the volume in the system player of Windows. But if you press [Ctrl+F10], it will work just like right-clicking the mouse.

And in Office apps, it works like [F6], which enables you to select specific sections and functions by pressing corresponding numbers or letters on the keyboard.

11. F11

This key is mainly used in browsers. Press [F11] once to enter the full screen mode, press it twice to quit the full screen mode.

In Word, pressing [F11] can go to the next field, which is mainly used in Word tables. You can combine it with the function of [F9].

12. F12

It’s another useful key that you should use a lot in daily life and work. In browsers including IE, Chrome, Firefox, etc. pressing [F12] can enable the developer tools.

As for Office apps like Word and Excel, you can press [F12] to quickly open Save As. Yes, you don’t need to go to File tab and select Save As in the menu, a single key can help you achieve the same goal.

There are tons of useful keyboard shortcuts in Windows as well as Office programs, most of them are combination shortcuts which require you to press two or more keys at the same time. But with F1

F12, you can press a single key and get a magic result. Why not make use of them in your work? After all, no one hates getting a good result with less time and effort.

Make fast changes with a function key shortcut

  • Tweet
  • Share
  • Email

LinkedIn Sales Navigator / Pexels

  • Tweet
  • Share
  • Email

The function key F2 allows you to quickly and easily edit the data of a cell by activating Excel’s edit mode and placing the insertion point at the end of the active cell’s existing contents. Here is how you can use the F2 key to edit cells.

Example: Using F2 Key to Edit a Cell’s Contents

This example covers how to edit a formula in Excel

If the option to allow editing directly in cells is turned off, pressing the F2 key will still put Excel in edit mode, but the insertion point will be moved to the formula bar above the worksheet in order to edit the cell’s contents.

Enter 4 into cell D1, 5 into cell D2, and 6 into cell D3.

Select cell E1 to make it the active cell.

Enter the following formula into cell E1

= D1 + D2

Press the Enter key on the keyboard to complete the formula. The answer 9 should appear in cell E1.

Select cell E1 to again make it the active cell.

Press the F2 key on the keyboard.

Excel enters edit mode and the insertion point is placed at the end of the current formula. This is the same as double-clicking the cell with the mouse.

Modify the formula by adding + D3 to the end of it.

Press the Enter key on the keyboard to complete the formula and leave edit mode. The new total for the formula (15) should appear in cell E1.

You can tell when Excel is in Edit mode by looking in the lower-left corner of the window. The word Edit will appear in the Status bar when Edit mode is activated.

Edit mode enables you to move the text cursor within the formula using the right and left arrow keys.

If you press F2 again, the formula goes into Enter mode. In Enter mode, you can use the arrow keys to select cells instead of moving the text cursor.

If you notice that when you press the F2 key, it increases the computer’s audio volume instead of making the cell active, you might need to press and hold the Fn key, which is in the lower-left corner of the keyboard just to the right of the Ctrl key, while pressing the F2 key.

Account Information

Share with Your Friends

3 ways to enter fields in Microsoft Word

3 ways to enter fields in Microsoft Word

Microsoft Word fields house instructions that help you create dynamic content; they’re flexible and powerful, if you know how to use them.

Must-read Windows coverage

  • Get Microsoft Office for Windows with this lifetime license
  • Kaspersky uncovers fileless malware inside Windows event logs
  • How to find your Windows 11 product key: 3 simple methods
  • How to enable access to god-mode in Microsoft Windows 11

Occasionally, a requirement simply can’t be easily met with the built-in features. Microsoft Word fields are similar to little bits of code that have a specific job. They return values that you can’t easily do in Word any other way. Fortunately, they’re easy to use once you get the hang of entering them properly. In this article, I’ll show you three ways to enter a Word field:

  • Use the interface
  • Ctrl + F9
  • Type and convert

I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier versions. Word fields aren’t supported by Word Online; the original values will display, but they won’t update, nor can you enter them.

About Word fields

You can insert fields to display content that will change when you update those fields. You might not realize it, but you’re already using fields. Page numbers, merge fields and so on are inserted automatically when you use those features.

You’ll notice as you work your way through the quick examples, that the function key, F9, plays a big part when working with fields. Specifically, here’s what this key does:

  • Ctrl + F9 enters a blank field.
  • Alt + F9 toggles all the fields in the document.
  • Shift + F9 toggles the selected field.

In addition to entering and toggling fields, you can modify them using switches. A switch is an additional bit of information; it always starts with a backslash (). Switches add formats and change the field’s behavior a bit. We won’t include switches in this article, but you’ll want to explore them later.

When you enter a field, the underlying field code will use the following syntax:

See Table A for an explanation of these elements.

Table A

This is the name of the code and determines what the field does. You’ll often see this part in all uppercase letters, but it isn’t case sensitive.

Optional instructions, but not all fields have them. In the interface dialog that you’ll see in the next section, these are referred to as Field Properties.

These are specific instructions, often to do with formatting that you can enable or disable. The character always denotes a switch.

When including fields in a document, remember that anyone viewing the document in Word can view the underlying codes, so be careful about including personal or confidential information. I’ve never run into this situation but it’s worth noting.

Now that you have a good feel for what fields are, let’s start inserting them. We’ll begin with the interface method.

How to insert a Word field using the interface

Word’s interface provides the most comprehensive method for inserting fields. Even if you find another method easier, I encourage you to review the interface so you can learn what fields are available and about their switches.

To enter a field using the interface, do the following:

  1. Position the cursor where you want to insert the field, which can be in the document body, or the header or footer.
  2. Click the Insert tab and then click the Quick Parts dropdown in the Text group.
  3. From the dropdown, choose Fields (Figure A).
  4. The resulting dialog lists the Word fields in the Field Names list, which you can filter using the Categories list. For this simple example, select Author and then select First Capital in the Format list as shown in Figure B.
  5. Click OK, and you’ll see the author’s name in the document (Figure C).

Figure A

Figure B

Figure C

You may have noticed a few other options in the dialog:

  • Field Codes will display the underlying field code.
  • Options will display formatting options and other specialized options that are specific to the field.
  • Preserve Formatting During Updates does just what it says: it preserves formatting.

You’ll want to explore the list of fields and their many options when you have more time.

You can use the interface to nest fields. After choosing one field, move the cursor inside that field and then return to the list and choose the second field. This capability takes a bit of practice. In fact, many users find it easier to enter a nested field manually.

How to insert a Word field by typing and converting

Perhaps the easiest method to enter any field is to simply type it, select it and then press Ctrl + F9. Doing so converts the text to the field(s). Let’s try this with again, the Author field:

  1. Position the cursor where you want to insert the field.
  2. Type Author
  3. Select the text you just typed (Figure D).
  4. Press Ctrl + F9 to convert the string into a true field. As you can see, Word adds the brackets.
  5. To display the field value instead of the field, press F9.

Figure D

This is a quick and easy way to enter a single field when you know the field code and any switches you might want to include. You can also use this method to insert a nested field, but you must insert each individually. You can’t type out an entire string and convert all the fields at once.

How to insert a Word field by using Ctrl + F9

The third method is similar to the previous method. Press Ctrl + F9 to insert a pair of empty brackets and then type the field code and any switches. Let’s try this method with the same < Author >field:

  1. Position the cursor where you want to insert the field.
  2. Press Ctrl + F9 to enter a blank field, as shown in Figure E.
  3. Enter the field code Author inside the brackets and press F9 to calculate the result.

Figure E

Word displays a field’s results rather than the field code, by default. Right-clicking serves as a toggle to display the underlying field code instead of its result. Doing so converts only the one field, so this is an easy way to quickly edit only one field.

For a full list of field codes, visit List of field codes in Word.

Microsoft Weekly Newsletter

Be your company’s Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets.

Take advantage of your Mac’s function keys

  • Saint Mary-of-the-Woods College
  • Tweet
  • Share
  • Email
  • Tweet
  • Share
  • Email

What To Know

  • To enable standard function keys, go to System Preferences >Keyboard, and enable Use F1, F2, etc. keys as standard.
  • Mac function keys are different than function keys on Windows and Linux.
  • Each key performs a unique function to control your Mac.

This article explains how to use the function keys on your Mac. Located at the top of your Mac keyboard is a collection of keys that feature an F followed by a number, 1-12. These keys, known as Mac function keys, enable you to change certain settings and reach Mac features quickly, with the press of a couple of keys.

Why Use Mac Function Keys?

If you’ve ever used a keyboard shortcut, you know how simple and fast it is. The time it takes to move your hand to your mouse or trackpad and navigate to the action you wish to take is cut short thanks to the shortcut. The function keys work the same exact way, saving you time as you work, surf the internet, or game.

Some apps allow you to customize the function keys to fit your preferences. You can also change your function keys to match your own shortcuts by remapping them. If there’s an action you take often using your Mac, the functions key can help.

Do you have a MacBook Pro (15-inch, 2016 and later) or a MacBook Pro (13-inch, 2016, Four Thunderbolt 3 Ports and later)? If so, your physical function keys are replaced by the Touch Bar, which changes automatically based on the apps you’re using.

The Function of Each F Key

Mac Function Keys
F1 Reduce the screen’s brightness
F2 Increase the screen’s brightness
F3 Activates Expose view, which shows you every app that’s running
F4 Showcases your apps or opens the dashboard for access to widgets
F5 For back lit keyboards, F5 decreases the keyboard’s brightness
F6 For back lit keyboards, F6 increases the keyboard’s brightness
F7 Restarts a music track or jumps to the previous track
F8 Plays or pauses a music track or other content
F9 Skip a music track or fast forward
F10 Mute
F11 Reduces volume
F12 Increases volume

How to Use the Mac Function Keys

By default, the function keys are ready to use without any other keystrokes. Simply press the key to activate the function you need to perform. The function will automatically activate.

You can also use other shortcuts such as modifier keys to save even more time as you work and play.

However, if you wish to change this, you can use System Preferences to enable standard function keys.

How to Enable Standard Function Keys

On your Mac, click Launchpad > System Preferences.

From there, click Keyboard, then click Use F1, F2, etc. keys as standard function keys.

Now, you’ll need to press the Fn key in the lower left corner of your keyboard plus the corresponding function key to complete an action.

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but the format of that imported data can vary drastically from one source to another.

For example, fields may be delimited, such as with tabs, spaces, commas, or periods. Aany other characters are all preferable to spaces. That’s because spaces not only exist in between fields, they also separate words within the fields, which makes sorting out the fields a real challenge. That’s where the following Text functions are very helpful.

A. Use the SUBSTITUTE function to replace one string of text with another

Function syntax: The syntax (or sentence structure) of the SUBSTITUTE function is this:

=SUBSTITUTE(text, old text, new text, [Instance Num]).

Note: If you don’t specify an Instance Num, every occurrence of the Old Text is changed to the New Text. If you specify the Instance Num, only that occurrence of the Old Text is replaced. For example, entering the number ‘1’ means you want to change only the first occurrence of that word in the string.

1. Enter some phrases in column A (from A2 through A13).

2. Enter the word or phrase you want changed in column B.

3. Enter the word or phrase you want to replace the old text with in column C.

4. Enter the following formula in cells D2 through D7 (or half the database): =SUBSTITUTE(A2, B2,C2,1)

This changes/replaces only the first occurrence of the Old Text to New Text.

5. Next, enter this formula in the remaining cells (in our case, D8 through D13): =SUBSTITUTE(A2, B2,C2). This changes/replaces all occurrences of the Old Text to New Text.

Note: This function is case-sensitive, so if your results aren’t working, change the text to all the same case.

01 Use the SUBSTITUTE function to replace one string of text with another

B. Extract the last word in a string of text using TRIM, RIGHT, & SUBSTITUTE

For this example, the object is to extract the last word—that is, the last name, from a string of text (the full names of a list of clients).

1. Enter some names in column A: first, last, and middle names or initials.

2. Enter this formula in B2: =TRIM(RIGHT(SUBSTITUTE(A2,” “,REPT(“ “,50)),50)).

3. Copy the formula from B2, down to B3 through B1000 (or the end of your database). For this example, we’re assuming your database has 1,000 records.

4. This formula works because the SUBSTITUTE function locates all the spaces in the string of text, and then replaces each single space with 50 spaces. The RIGHT function removes 50 characters (from right to left), and the TRIM function deletes all the excess leading spaces leaving just the single, last word. If you have longer strings of text, try substituting 100 or more for the 50 values in the above formula.

PC World / JD Sartain

Extract the last word in a string of text

Further Excel training

If you want to deepen your Excel mastery, a number of online courses exist to expand your knowledge. Here are our top picks to start with:

C. Extract the first word/name in a string of text using LEFT & SEARCH

This formula works when you need to separate the first name from the middle and last name of a list of clients.

1. Enter some names in column A (or use the same names from the previous exercise).

2. Enter this formula in B2 through B1000: =LEFT(A2,SEARCH(“ “,A2)-1) to extract the first name of each client into a separate column.

Extract the first word/name in a string of text

D. Extract everything except the first word in a string of text using TRIM, RIGHT, REPT, & SUBSTITUTE

The purpose of this exercise is to remove the honorifics from a list of client names. These clients are providing confidential survey information, so the company does not want the titles and salutations of each individual to influence the surveyors.

1. Enter some more names in column A (or use the same names from the previous exercise). Enter some honorifics before each name; e.g., Mr., Miss, Ms, Mrs. , Dr., Sir, Lord, Lady, Capt., etc.

2. Enter this formula in B2 through B1000: =TRIM(RIGHT(SUBSTITUTE(TRIM(A2),” “,REPT(“ “,60)),180)) to extract the full names of all the clients minus the honorifics.

3. And, if you wanted to extract the honorifics (for some reason), enter this formula in C2 through C1000: =LEFT(A2,SEARCH(“ “,A2)-1).

Extract everything EXCEPT the first word in a string of text

E. Extract names from email addresses using LEFT, FIND, & SUBSTITUTE

The worst job of the day is to spend hours manually retyping client names or domain names from email addresses, especially when the list is over 5,000 names. Use the following formulas to complete this task in minutes.

1. Enter some email addresses in column A.

2. Enter this formula in B2 through B5000: =LEFT(A2,FIND(“@”,a2)-1) to extract the full names of all the clients.

3. Enter this formula in C2 through C5000 to remove the underscore between the first and last name: =SUBSTITUTE(B2,” “,”_”).

4. Move to cell F2. Select Formulas > Text > . Type C2 in the Text field box on the Functions Arguments dialog screen, or click cell C2, and then click OK. This formula converts the names to Proper Case (that is, first letter of the first and last name capitalized, all other letters in lowercase).

5. Copy the formula in F2 to F3 through F5000 and press Enter.

PC World / JD Sartain

Extract names from email addresses

G. Extract domains from email addresses using TRIM, LEFT, SUBSTITUTE, MID, FIND, LEN, & REPT

1. Enter this formula in D2 through D5000 to extract the domain names from the email addresses:

=TRIM(LEFT(SUBSTITUTE(MID(A2,FIND(“@”,A2),LEN(A2)),” “,REPT(“ “,100)),100))

2. And last, enter this formula in E2 through E5000 to remove the @ signs from the extracted domain names: =SUBSTITUTE(D2,”@”,””).

What are the Resharper 4 shortcuts to

Create a class from usage? e.g. I type “var p = new Person();”, and I want to now create the person class.

Move this class to its own file? When the Person class exists in the same file next to my Order class, what is the shortcut to move it.

I can’t seem to find these shortcuts on the cheatsheet or the Internet.

1 Answer 1

Type the line out:

Person will be highlighted in red as an error by ReSharper. Put the caret on it and press ALT + ENTER to invoke the quick-fix context menu. Select Create class ‘Person’.

The cursor will then be on the new class’ name, so press ALT + ENTER again to invoke the context-sensitive quick-fix menu again and select Move to another file to match type name.

That’s just two actions – really quick and easy. After a while, it (like most R# commands) becomes muscle memory. Like driving, walking or chewing gum.

FOR BONUS POINTS
The above is all you need to do what you wanted, but you can take it a step or two further:

If you’d rather the class was moved to a different namespace, you can press SHIFT + CTRL + R and select Modify Namespace. .

If you’d rather the class was moved to a different project entirely, you can press SHIFT + CTRL + R and select Move to Folder. .

The great thing is – ReSharper will make all necessary changes to namespaces to make sure things still compile. With one gotcha – only if the project you move the classes to is referenced by the one you move them from. You have two choices

  1. Go ahead with the refactoring and use ReSharper quick-fixes to both add the reference and import namespaces in one go (if it’s a new class, I’d do this because it’ll be the only usage).
  2. Add the reference manually before moving them and it’ll do it all for you.

From OneNote Gem – Favorites 15.0.0.53, it add a set of bookmark features to add, delete and go to bookmark.

Add a Bookmark in OneNote ( Keyboard Shortcut Ctrl+F2 )

  1. Select a paragraph, or put the cursor in the paragraph.
  2. Click the “Navigation” tab -> “Bookmark” group -> “Add” command, or simple press keyboard ” Ctrl+F2 “.

Delete a Bookmark in OneNote ( Keyboard Shortcut Ctrl+F2 Again )

To delete the bookmark, repeat the operation again

  1. Select a paragraph, or put the cursor in the paragraph.
  2. Click the “Navigation” tab -> “Bookmark” group -> “Add” command, or simple press keyboard “Ctrl+F2“.

The “Gem” will find exists bookmarks, it will delete the bookmark of the paragraph.

Go to Bookmark (Keyboard Shortcut F2 )

After insert bookmarks in OneNote, you can view the bookmarks in “Bookmark” menu, and click them to jump to the bookmark paragraphs.

Or simple press keyboard key F2 to loop jump to the list bookmarks in sequences.

Remove all Bookmarks

Click the “Navigation” tab -> “Bookmark” group -> “Remove All” command to remove all bookmarks in OneNote

From the starting days of my job, I have learned one thing hard way:

Before sending a report (In Excel) to someone we must convert a formula to value. It simply means to replace a formula with its result value. Just think this way, when you send a report to someone, they are not concerned with formulas but with the values, a formula returns.

Let me tell you some of the interesting ways to do this but before that.

Why You Should Convert a Formula to Value

Here are some reasons why you need to replace a formula with its result value.

  1. If you are sending a report to someone without its source data then it’s better to convert all the formulas into static values.
  2. Some functions are volatile and when you update your worksheet their value will recalculate.
  3. To prevent the end-user to make any change in the calculation.
  4. Static values are easily editable and anyone can copy-paste them easily.
  5. You don’t want to confuse end-user with complex formulas.
  6. Or, simply don’t want to show the formulas.

Quick Note: It’s one of those Excel Tips that can help to get better at Basic Excel Skills.

1. Paste Values with a Simple Keyboard Shortcut

When it comes to speed and ease, shortcut keys are the best and to turn formulas into values the easiest way is to use a shortcut key.

All you need to do:

  • Select the range of the cells where you have formulas.
  • Press Ctrl + C to copy cells.
  • And then, Alt + E S V.

By using this shortcut key all the formulas will be replaced with their static result value.

Note: If you don’t want to lose original formulas then you should make a backup file.

2. Using Paste Special for Converting to Values

If you don’t like to use a shortcut key then you can simply use the paste special option to replace it.

  1. First of all, select your data range or the entire column.
  2. And then, right-click and copy it.
  3. Go to Home Tab ➜ Clipboard ➜ Paste ➜ Paste Special.
  • Or, you can also press right-click and go to Paste Special -> Values.

This method just works like the shortcut key method to replace all the formulas into their static result values.

3. Using Right-Click Menu

And if you don’t want to use paste special then you can use the right-click drag-drop method for this conversion. Here are the steps:

  1. First of all, select the range of the cells where you have formulas.
  2. Now, right-click on the edge of the selection.
  3. And by holding the right-click, drag the range to the right side and instantly bring it back to the original place and drop it.
  4. Here you will get the options menu.
  5. From this options menu, select “Copy Here as Values Only”.

This will instantly convert all the formulas from those cells into static result values.

4. Convert Formulas into Values with a VBA Code

If you want to automatically convert all the formulas into text or numeric values then you can use VBA for that. Here I have mentioned a simple VBA code where you just need to select the range of the cells and run this macro.

5. Convert To Values Inside the Formula

Let’s think differently. You have a complex formula which is a combination of two or three functions. Here you have a long formula to clean a text value and then convert it into the proper case.

Now if you want to convert the result of two substitute functions in static text values, here are the steps.

  1. Edit the formula using F2.
  2. Select only that part of the formula which you need to convert to a static value.
  3. Press F9.

Now you just have a text value to convert into the proper text case.

6. Get Formula’s Result Value with Power Query

There could be a situation when you need to get the result value of a formula in a separate cell instead of simply converting them. And in that case, you can use a power query.

You need to convert it into values before sending it to your customer. But the thing is you don’t want to lose all the formulas. So here are the simple steps to get values from formulas using power query.

  • Select the table and go to Data Tab ➜ Get & Transformation ➜ From Table.
  • It will open your table into the power query editor.
  • From here, just click on “Close & Load”.
  • Now the power query will insert a new table in a new sheet where you have price values instead of formulas.

The best part is when you make any changes in your formula table you just need to refresh the power query table. By using this way you don’t need to copy-paste data every time.

Conclusion

Sometimes using complex and large formulas make your workbook heavy in size, so it’s better to convert them into absolute values before sharing them with others.

And all the methods which we have discussed above can help you in different situations. If you ask me, my favorite one is the keyboard shortcut but I also like to use power query sometimes.

I hope you found this tip useful, but now, tell me one thing.

What’s your favorite one? Do you have any other method which you use while converting formulas into values?

Please share with me in the comment section, I’d love to hear from you and don’t forget to share this tip with your friends, I’m sure they will appreciate it.

How to add or remove Copy To folder and Move To folder context menu in Windows 11? If you are also trying to find a guide, you come to the right place. In this post, MiniTool provides you with a step-by-step guide with clear screenshots.

Windows 11 is a fully new operating system compared with other Windows operating systems. This version brings many new features and changes. One of the biggest changes is the Windows 11 context menu. When right-clicking an item in File Explorer Windows 11, you will find a modern condensed context menu with Show more options. It may be inconvenient and time-consuming for those who want to find their desired options quickly. So, many people want to get full context menu in Windows 11. In addition, users can add the “Copy To folder” and “Move To folder” context menu that the files or folders can be copied and moved immediately after selecting.

How to add or remove Copy To folder/Move To folder in Windows 11? This tutorial will show you detailed steps and provide clear screenshots.

Microsoft released the Windows 11 Insider Preview 22483. Where and how to download the Windows 11 build 22483 ISO? Now, get detailed information from here.

How to Add or Remove “Copy To folder” and “Move To folder” Context Menu in Windows 11

Before you start the following steps, you need to make sure that you signed the system as an administrator. Once signed in, you can add or remove Copy To folder and Move To folder context menu in Windows 11.

Method 1. Use the “Copy To folder” and “Move To folder” REG File

To add or remove Copy To folder and Move To folder context menu in Windows 11 directly, you can use a REG file to set it. Here’s how to do that:

Step 1. Click here to download the Add_Copy-Move_To_Folder_to_context_menu.reg file and save it on your desktop.

Step 2. Double click the downloaded .reg file to open it and click on Yes or Run in the confirmation window to execute the operation.

Step 3. Now, you will receive a warning message whether you want to continue. If you are sure, click on Yes.

Step 4. To use the Copy To folder and Move To folder context menu, you can right-click the file that you want to copy or move and select Show more options. Then select your desired option in the full context menus.

Of course, you can delete the downloaded .reg file if you like.

Method 2. Use Registry Editor

Another method to add or remove Copy To folder and Move To folder in Windows 11 is to manually change some value keys in Registry Editor. To do so, follow the steps below carefully.

Step 1. Press Win + R keys to open the Run dialog box, and then type regedit in it and hit Enter. Click on Yes in the pop-up UAC window to confirm the operation.

Step 2. In the Registry Editor window, locate the following path via the left navigation bar.

HKEY_CLASSES_ROOT\AllFilesystemObjects\shellex\ContextMenuHandlers

Step 3. Right-click the ContextMenuHandlers folder and select New > Key to create a new folder. Then name the folder Move To folder.

Step 4. With the Move To folder key selected, double click the Default string from the right hand and enter the following key to the Value data box and click on OK. After that, you will see the Move To folder option in the full context menus.

Step 5. In the same location as Step 3, right-click the ContextMenuHandlers folder again and select New > Key to create a new folder. Then name it Copy To folder.

Step 6. With the Copy To folder key selected, double click the Default string from the right hand and enter the following key to the Value data box and click on OK. If you don’t want to use the option in the future, you can delete the Copy To folder key in the same location.

How to add or remove Copy To folder and Move To folder in Windows 11? The 2 ways have been illustrated. Now, it’s your turn to have a try.

A great many people are unclear about how to map a network drive in Windows 11. If you are also trying to figure it out, then this post is what you need.