Change Outlook signature - this is how!
Change Microsoft Outlook signature - explained quickly and easily!
How to change the Outlook signature? In the past, when all letters were still sent in paper form, the so-called farewell formula could not be missing under any circumstances. Something like „Best regards“ or „Yours sincerely“ and a personal signature was a must. But who actually says that this should no longer be the case in e-mail correspondence today? If you work with Microsoft Outlook, for example in Windows 11 or Windows 11 Home, you can easily create an Outlook signature and change it at any time.
Do I have to create an Outlook signature?
That depends on whether you are writing a purely private or a business e-mail. In the business sector, a signature has been mandatory for e-mails since 2007. This means that for self-employed persons, freelancers or companies, as soon as they send an invoice or an offer by e-mail, the same information as in an imprint must be included as sender information. These minimum details are mandatory:
- Company name
- full name of the owner
- summonable address
Fortunately, with Microsoft Outlook 2021, this can be done in almost no time at all. And a great company logo, a ready-made signature or even a portrait of the sender can also be easily integrated when you want to create the Outlook signature.
And this is how it’s done
For example, in the Microsoft Outlook 2019 Multilanguage full version with the Windows 11 Pro or Windows 11 Pro N operating system, signatures can be automatically attached to all outgoing mails. It is also possible to add a signature to individual e-mails. If you want to change an Outlook signature, proceed in the same way:
- To do this, first open a new e-mail message.
- Select the option „Signature“ in the menu “ Message „.
- Under „Edit signature“select the option „New“.
- In the „New Signature“ dialogue box, give the signature a name.
- Use „Edit signature“ to write the personal farewell formula. The font, font size, text alignment and colour can be easily specified. If you want to change the Outlook signature later, each individual point can also be edited later.
- Using the option „Select default signature“ in the drop-down menu „E-mail account“, first select the corresponding account to which the signature is to be assigned.
Tip: Each e-mail account in Outlook, for example in Windows 11 Education, can be given its own individual signature. The more individual and specific these are, the more personally the recipients feel addressed. In a business context, this can have a more professional effect.
- If all messages are to receive the signature, select one of the signatures in the drop-down menu „New messages“ .
- If you do not want all new messages to automatically receive a signature, simply click (none)
- If the signature is also to be shown on reply mails or forwards, select an appropriate signature under „Replies/Forwards“.
- If this is not necessary, select the standard option (none).
Add signature manually one by one
If you have decided not to automatically add a signature to every e-mail, you can still add a signature, address, picture, etc. to individual e-mails afterwards. Select an individual e-mail and choose the option „Signature“ on the „Message“ tab. In the flyout menu, each signature created can now be selected to be displayed under the individual message.
Add picture, logo and signature
With Microsoft Outlook, a signature with pictures can also be created or the Outlook signature can be changed accordingly under Windows 11 Enterprise and Windows 11 Pro for Workstation.
- To do this, select Signature> Signatures in a new e-mail.
- In the field „Select signature for editing„, click on the signature that is to be provided with a logo, an image or with the digitised signature (as an image).
- Now select a corresponding image file on the PC with the icon Image and connect it to the signature by clicking on „Insert“.
- With a right mouse click on the picture under the tab „Size“ adjust the area of the picture.
Tip: If the „Lock aspect ratio“ check box is activated, the image ratios are retained.
Header Image: ©monticellllo, stock.adobe.com
Move folders in Microsoft Teams - this is how!
Move folders in Microsoft Teams - explained quickly and simply
Move to Teams Folder sounds simple, but it’s not that simple. With Windows 11 Home and also Windows 11 Pro for Workstation you can do quite a lot. Especially if you also have a tool package such as Microsoft Office 2021 Standard or Microsoft Office 2021 Home and Business is installed. Especially recently, teams has established itself as one of the most popular programmes. But it is precisely here that a problem occurs time and again, which is actually based on a misunderstanding: If you want to move folders in Teams, it simply does not work. What to do then is explained here.
The „Folder“ function in Teams
With, for example, the Microsoft Office 365 Home for example under Windows 11 Pro N you can collect files in folders in the Teams tool. In this way, related files are grouped together and the overview is not lost.
- To now be able to share a team folder between several people, in the dashboard of the admin console first click on „Create Team Folder“ in the dashboard.
- In the next step, select the storage location by clicking on „Existing Mandate Storage“ and then „Default Client Storage“ is selected.
- Now name the folder with a short, concise name Name (please do not use any special characters!). Go to „Next“ button.
- Distribute the access authorisations under „Staff“ and in the second step „Add responsible persons is possible.
After a few moments, the folder is available to all authorised participants either on the Datastore drive, for example in Windows 11 Education or Windows 11 Enterprise or it is displayed on the computers, for example with Microsoft 365 Family on the web interface. However, it is not easy to move the Teams folder.
Moving teams folders is only possible in a roundabout way
Of course, it would be practical to be able to move a Teams folder with a simple mouse click. Some users are annoyed that this does not work so easily. Microsoft itself is well aware of the problem, and when asked, the company promises to come up with something Until then, however, there is only one way to move Teams folders. And that is via SharePoint.
What is SharePoint?
This is a website-based system that optimises collaboration between different employees, certain workflow applications, list databases and security functions. Numerous companies use the programme, for example, as an intranet, company portal, document management system or as a pure knowledge database. The greatest advantages of SharePoint are the automation of time-consuming manual tasks, the structured organisation of data and the enormous time savings due to less internal e-mail traffic. Many Microsoft packages include SharePoint as an integrated tool, but the cloud version SharePoint Online is also available With SharePoint it is possible, for example, to Microsoft 365 Business Premium Websites can be created and information can be securely stored, structured – and also shared. To move a folder that was created in Teams, proceed as follows:
- Select the folder to be moved and click on the right on the „three-point menu on the right.
- Option „Open in SharePoint option.
- The folder and the files it contains are now automatically saved in SharePoint.
- Now the folder can be placed at another location, such as a higher hierarchy level, in two different ways.
Method 1: by drag & drop
- To do this, simply „hold“ the corresponding folder with the mouse cursor and drag it to the desired level
- To ensure that the folder is now displayed in the correct place, refresh the page in the next step
- In the browser, such as Chrome, go to the „View“ tab.
- Select the option „Reload This Page“.
Method 2: via „Move to
- In the „three-point menu“ next to the folder, you can now select the option „Move to can be selected.
- A menu opens on the right-hand side of the screen.
- Select the option „Search Website“.
- Click on the corresponding team event.
- Select the destination.
- If necessary, select a sub-destination and click on the menu item „Move here“.
Header image: ©Renan, stock.adobe.com
Draw shapes in OneNote - this is how!
Drawing shapes in OneNote - explained quickly and easily
How to draw shapes? OneNote, for example, in Microsoft Office 2021 Standard on Windows 11 is considered one of the best tools when it comes to making quick notes, records or sketches. For better illustration and overview, a circle or a triangle, for example, can be drawn in different ways – with the Surface Pen or freehand in OneNote. We show here how this works in the Microsoft 365 Family programme, for example, in the Windows 11 Home operating system.
Draw shapes easily with the graphics tablet
With a special graphics tablet or a tablet PC with the Windows 11 Pro or Windows 11 Pro N operating system, in which Microsoft Office 365 Home is installed, for example, you can freehand draw whatever comes to mind in OneNote. Simply draw a rectangle, circle or triangle with the Surface Pen next to, below or in the middle of the notes. Handwritten notes, stick figures or anything else you like can also be drawn on the screen just like on normal paper.
Draw a rectangle with your finger only? Of course!
If you don’t have a special pen to draw with at the moment, you can also simply put your shapes and notes „on paper“ with your finger or the mouse.
- First select the option „Drawwith mouse or finger“ in the „Draw“ menu.
- In the same menu you can now select the pen thickness. You can choose between a thin or medium pen shape.
- With the option „Freehand colour“ you can determine the drawing colour.
- Now you can draw on the touch screen with your finger or on any other PC with the mouse cursor.
If you don’t like it, just delete it
Anyone can make a mistake. No problem in OneNote, mistakes or unattractive drawings can be easily erased:
- Tap on „Eraser“ and select one of the following options:
- „Medium eraser“ manually erases certain parts of the drawing.
- „Brush stroke eraser“ deletes entire drawing gestures, i.e. sections of the drawing, with one tap.
Drawing shapes more neatly with the defaults
Of course, anything freehanded into shape with the Surface Pen in OneNote looks suitably wild. Especially if you want to show your notes or individual sections to others, you can draw neater shapes with the presets in the programme under Windows 11 Education or Windows 11 Enterprise in Microsoft Office 2021 Home and Business, among others. To do this, simply call up the „Shapes“ function. The menu then shows predefined geometric figures. Simply select the appropriate one and place it in the right place on the page in One Note. To do this, click with the cursor on the place where you want to draw a circle or a rectangle, for example. Then select the corresponding shape by holding down the left mouse button and it appears in the previously selected place. With the markings that appear around the shape, you can now draw everything larger or smaller. Moving the shapes and, of course, deleting them are also child’s play.
All in one with „Freehand in Shape
One of the most practical functions of OneNote in Microsoft 365 Business Premium, for example, under Windows 11 Pro for Workstation is „Freehand in Shape“. It is located on the Draw tab. A click on the button switches on automatic shape recognition.
- First, the function at the top of the menu is switched on.
- Now draw the desired shapes with the Surface Pen as usual.
- OneNote recognises the shape on its own and automatically converts it with clean, even edges.
- At the end, simply deactivate „Freehand to Shape“ in the menu again.
Tip: Right next to the „Freehand in shape“ function you will find the option „Freehand in text“. The selection automatically converts handwritten text passages into more legible print.
Header Image: ©monticellllo, stock.adobe.com
Crop PowerPoint image - this is how to do it!
Crop PowerPoint image - explained quickly and easily
Anyone who works with Microsoft Office 2021 Standard or Microsoft Office 365 Home under one of the Windows 11 operating systems, for example, will sooner or later also use the PowerPoint presentation programme. There are a few tricks and turns that make working with it much easier. For example, you can easily crop a PowerPoint image to highlight certain PowerPoint image sections. Our instructions show how this works.
Why do you have to crop a PowerPoint image?
You don’t have to – but you can! And that’s exactly the big advantage that Microsoft Office 2021 Home and Business, Microsoft 365 Business Premium and Microsoft 365 Family offer. After all, it is usually the case that in both the business and private spheres, you don’t necessarily want or need to see everything that can be seen on an image that you want to present. Or it is important to draw attention to only a single section of the picture. The possibility of highlighting image sections and cropping images with PowerPoint 2021, for example, is therefore ideal. After all, a presentation with images lives through appealing motifs, impressive image details and surprising shapes. This underlines the message of a text and arouses the viewer’s curiosity. If you can crop a digital photo and highlight it as a PowerPoint image section, you can greatly enhance your presentation on a PC with Windows 11 Pro or Windows 11 Pro N operating system.
Cropping images – this is how it works
You do not need a special programme to crop a PowerPoint image. With the tool under Windows 11 Education or Windows 11 Enterprise itself, you can easily crop a photo in just a few steps:
- Under tab „Insert→ Images“, the motif is first inserted at the appropriate place on the slide.
- Leave the image activated and then go to the „Image tools“tab
- In the „Size“ group, click on „Crop“
- Now the photo can be cropped – to a specific shape or according to a desired aspect ratio.
- The marked section in the picture can now be enlarged, reduced or moved to the desired size with the help of the crop marks.
- When everything is the way you want it, all you have to do is click next to the shape so that PowerPoint saves the changes.
With the Image Format → Reset Image → Reset Image and Size tab, the whole process can be undone.
Crop more than one PowerPoint image at a time
Sometimes it is practical to be able to crop not just one, but several images at the same time with PowerPoint under Windows 11 Pro for Workstation, for example. For example, when two images are placed next to each other on the slide but are too large or too small. Then simply hold down the CTRL key and drag the side crop marker inwards or outwards accordingly. If you want to crop all four sides of the PowerPoint images, you again hold down the CTRL key and then drag one of the crop marks at a corner accordingly.
The special shape creates atmosphere
If pictures are always displayed in a rectangular or square shape, they can become a bit boring. However, you can create a special atmosphere if you not only crop PowerPoint pictures, but also give them an unusual form of presentation.
- To do this, select an image and clickon the upper half of the “ Crop“button in the „ Image format“ tab
- Select „Crop toshape
- Select the appropriate shape such as an ellipse, a circle, a hexagon or similar. The photo now automatically appears with the outline of the selected shape.
- Then click on the upper half of the „Crop“ button to make the crop marks appear.
- Now adjust the size and proportion of the shape.
- Within the shape, the image can be moved to find the right crop.
- A mouse click outside the marks saves the picture in its chosen shape.
- With the keyboard command „Ctrl + Z“ the result can be undone.
Header image: ©vladim_ka, stock.adobe.com
OneNote: How to integrate a notebook into teams
OneNote: How to integrate a notebook into teams
Many still cope with everyday work without a OneNote notebook: you have an idea and jot it down on a piece of paper in between. You also scribble down the telephone number you want a colleague to call you back. You discover a great savings offer on the internet and write down the URL on a piece of paper … In no time at all you get lost among all these pieces of paper and in the end you can’t find anything anymore. But all those who have signed up under one of the packages of Windows 11 for example with the Microsoft Office 2021 Standard or Microsoft Office 365 Home have a tool at hand that makes this paperwork unnecessary: the OneNote notebook.
What is the OneNote notebook?
Word, Excel, PowerPoint and Outlook are familiar to anyone who works on a PC with Windows 11 Home, Windows 11 Pro or Windows 11 Pro N, Microsoft Office 2021 Home and Business or Microsoft 365 Family on a PC. But very few people know that the OneNote notebook is already installed there. This is a digital notebook that can replace calendars, notebooks and memos. Sketches, handwritten notes, graphics, pictures, lists and documents can be conveniently inserted and managed. Multimedia content such as e-mails, websites and videos can also be organised well with the OneNote notebook Since you can also save all content in a cloud, there is no danger of misplacing or forgetting anything.
OneNote as part of Teams
One of the components of the Microsoft Office suite such as Microsoft 365 Business Premium in the operating system Windows 11 Education or Windows 11 Enterprise is the communication platform Teams. OneNote is also integrated into this. Working with it facilitates many processes and is very simple: [/vc_column_text ]
Create a new notebook
- On the Office start page, click the OneNote icon on the left.
- Click on the button "+ New notebook".
- Enter the title for the notebook and confirm with "Create".
- You will be prompted to press the enter key to create a first section in the OneNote new notebook.
Share notebook
To work together, the OneNote notebook can be shared:
- In the web under OneNote open the Open the notebook, that you want to share.
- At "File" select "Share then select "Share with others".
- In the left column under "Share" you must "Invite people must be activated.
- In the field "To" enter the e-mail address of the person with whom you want to share the OneNote notebook.
- In the field below you can enter a short Note for the recipient.
- If you do not want the recipient to be able to edit the contents after sharing the OneNote notebook, you have to click on the blue link "Recipients can edit items" change the settings for the permissions.
- Send the invitation with "Share".
Exporting the OneNote notebook
For example, as a backup copy or to use the notes in another format, individual sections or even an entire OneNote notebook can be exported:
- In OneNote open the Open the page that you want to export.
- Click on " Export" in the "File " tab.
- Specify whether the computer should export only a section or the entire OneNote note book.
- Format for the export. You can choose between the OneNote format, PDF or Word.
- Click on "Export" and select a storage location.
Exporting a saved OneNote notebook
If the notebook is stored in a cloud or on OneDrive, for example, it must also be exported in order to continue working on it. This is how you proceed:
- With the Microsoft user account log in.
- In the navigation "More notebooks select.
- At "My notebooks click with the right mouse button on the corresponding notebook.
- A new menu window appears, in which click on "Export Notebook click.
- Set storage location
The PC automatically creates a zip file of the exported OneNote notebook. This just needs to be unzipped to use the notebook as usual.
Header image: ©monticellllo, stock.adobe.com
PowerPoint - Fade in pictures one after the other
PowerPoint - Fade in pictures one after the other
Creating a PowerPoint presentation is one thing. It is another to make this presentation varied as well. In this tutorial, we explain how to add effects and fade in PowerPoint images one after the other when creating a PowerPoint presentation.
What your PC must have for PowerPoint 2021
Old computers are no longer suitable for the new version of PowerPoint. In any case, Windows 11 is the best operating system. The highly complex tool PowerPoint 2021 can be used to its full potential with Windows 11 Home and Windows 11 Pro or Windows 11 Pro N, among others. The software with which a PowerPoint presentation can be easily created includes, of course, Microsoft Office 2021 Standard. Microsoft Office 365 Home and Microsoft 365 Family also run excellently on the Microsoft operating systems Windows 11 Education and Windows 11 Enterprise. In the professional or semi-professional sector, Microsoft Office 2021 Home and Business and the office software Microsoft 365 Business Premium have proven their worth. The complete package Windows 11 Pro for Workstation is the best choice here.
How to add effects to pictures in PowerPoint
If you want to fade in pictures one after the other on one of the Windows 11 systems, for example with Microsoft Office 2021 Standard or Microsoft 365 Family PowerPoint, you first have to add effects to them. To do this, first click on the image on the slide that is to appear first in the presentation. Now navigate to the „Animations“ tab and select the effect that suits best in the „Animation“ group.
4 basic types of possible animations
The numerous animation effects that PowerPoint provides under Windows 11 Home, Windows 11 Pro or Windows 11 Pro N under Windows 11 Education, Windows 11, Enterprise or Windows 11 Pro for Workstation, for example, can be divided into four basic types:
- Input: Determines how the image appears in the presentation slide.
- Focus: With a mouse click, objects can be rotated with the cursor.
- Exit: Determines the effect with which the image leaves the slide.
- Motion paths: This makes the animated objects „slide“ across the slide on a predefined path.
Easily fade in PowerPoint images one by one
After each picture has been provided with effects, they should now also be faded in in a certain order. To do this, the start behaviour of each animation as well as its duration must be defined. To enable PowerPoint to fade in images one after the other, proceed as follows:
- Duration: Click on the animated image, enter the number of seconds the image is to be displayed in the „Duration“ field in the „Display duration“ group.
- Delay: Here you can delay the animation of individual images after the actual start. Here, too, the duration of the delay must be entered in seconds.
- Start: The time at which an animated image is to appear can be selected through various options:
- „Start at Click“ starts the animation with a mouse click.
- „With previous“ makes the animation start at the same time as the one in the sequence before. Caution: With this setting, several animations are visible at the same time!
- „After Previous“ lets the PowerPoint images fade in one after the other, but immediately after the previous effect
- „Preview“ in the „Animations“ tab allows you to test the animations in their order.
Tips for organising the effects
With all the possibilities that PowerPoint 2021 offers, it is easy to lose track of the number of effects and animations. To prevent this from happening, it is very easy to organise all the effects. If you first click on the „Advanced animation“ option in the „Animations“ tab and then on „Animation area“, the complete animation area appears. Here, all the selected animations of the slide are displayed in order. Now you can easily change settings such as the duration or the start of the effect. With the right mouse button, you can access a context menu that offers numerous other options. Incidentally, the order in which the animations are to take place can be changed quite simply by dragging and dropping.
Header image: ©Gorodenkoff, stock.adobe.com
Marking text precisely in Word
Accurately highlight text in Word - here's how!
Anyone who uses Windows 11 Home at home or Windows 11 Enterprise at work and works with Microsoft Word 2021 or Microsoft 365 will want and need to use this function from time to time: Marking text passages in Word. There can be many different reasons for this, but it often leads to problems, especially with longer texts – if you don’t know our little tricks, which we explain here.
Reasons why you have to mark text passages in Word
Sometimes you have to mark a word, a sentence or a single paragraph in a Microsoft Word text document, sometimes even entire passages, which can often extend over several pages. This may be necessary, for example, if you want to copy a paragraph in the text or delete it completely. Even if you want to display certain passages in the document in a different font or colour, if you want to set a sentence in bold or italics, you have to mark the corresponding place in Microsoft Word. If you want to format a text, it is sometimes necessary to underline certain passages in colour, set up indents or add text characters or bulleted lists to individual paragraphs. For all this, the desired part of the text must be marked in Word.
Marking areas in Word – these methods are available
There are various approaches to formatting a text or marking it in Microsoft Word, which we would like to examine in more detail here.
- Mark text passages in Word with the left mouse button: This is probably the most common method used by many users. Simply place the cursor at the beginning of the passage to be marked and then, while holding down the left mouse button, drag it to where the end of the mark should be.
- Double-click and triple-click: If you click twice quickly on a word with the mouse, it is automatically marked. A quick triple-click marks the clicked paragraph.
- Key combination „Ctrl+A“: If you want to save yourself the trouble of using the mouse, simply select this key combination to mark the entire text in Word.
- Use key combinations to highlight individual letters: If you only want to highlight individual letters or characters, these key combinations can be used by holding down the „Shift“ key:
- Right arrow marks the next character
- Left arrow marks the previous character
- Up arrow marks the line above it
- Arrow down marks the line below
- Mark whole text parts with key combination: Slightly more than single characters marks the key combination „Shift+Ctrl“ together with:
- Right arrow to mark the next word or the current word from the cursor position to the end
- Left arrow marks the previous word or the current word from the cursor position to the beginning
- Up arrow sets a text marker to the beginning of the paragraph
- Down arrow marks the current paragraph to its end
- Marking with the F8 key: If you want to mark individual parts of text from a paragraph in Microsoft Word – whether in the 2016 Multilanguage full version or the 2019 Multilanguage full version – placing the cursor precisely in the right place can quickly go wrong. However, if you place it at the text position from which you want to mark and then press the F8 key, it becomes really convenient. Then all you have to do is move the cursor to the place where you want the selection to end – and exactly this section in between is marked. If you have perhaps not hit the exact spot with the cursor, that is no problem either. The end point can be placed at another position at any time using the F8 method.
- If the F8 key is pressed twice in succession while the cursor is stationary, the word on which the cursor is currently resting is marked – similar to a double mouse click. Pressing the key three times highlights the current paragraph, and pressing the „magic key“ five times highlights the entire text in the Microsoft Word document from Microsoft Office 2021 or Microsoft 365.
If you have pressed once or twice too often, you can return to the previously set selection with the combination „Shift+F8“. The Esc key ends the marking mode.
Header image: ©lassedesignen, stock.adobe.com
Activate macros in Microsoft Word and Excel
PowerPoint: Edit the Excel link without problems
Anyone who works with Microsoft Office 2021 or Microsoft 365 has probably heard about it: you should activate macros to be able to work more effectively. Microsoft Word and Microsoft Excel in particular are supposed to benefit from this. But many people don’t know what these ominous macros actually are and how to activate them. For all those, here are our instructions.
What are macros in Microsoft Word and Microsoft Excel?
Basically, macros are commands on the PC that enormously facilitate and accelerate work processes that are carried out again and again. This means that macros in Microsoft Word or Microsoft Excel, for example, save these commands and automatically make them available as needed with a simple click of the mouse. Such recurring instructions or commands are executed together with the help of macros either via the mouse or via a key combination. In Excel spreadsheets, for example, data can be quickly organised, formatted and imported by clicking on a defined symbol or using a specific key combination. Or constantly recurring phrases in correspondence, such as „Yours sincerely“, do not have to be typed under the letter, but can be inserted automatically under every letter with a macro. A text that has been written once or a sequence of frequently used commands are therefore automatically recorded or executed by the macros. In order to be able to do this, however, they must first „learn“ which work steps they should save. You must therefore first activate the macros in order to work with them.
Activating Macros in Microsoft Office 2021
First you decide whether you want to activate Excel macros or Word macros. Accordingly, open the desired programme in Microsoft Office 2021 or Microsoft 365 and proceed as follows:
- In Microsoft Word or Microsoft Excel 2010, go to the File tab.
- Select Options.
- Go to the section Security Centre (Trust Center).
- Click on the button Settings for the Trust Center.
- Now go to the section Settings for Macros (Macro Settings).
- Click on Activate all macros (Activate VBA macros).
- Confirm changes with OK.
Now the macros can be programmed in Microsoft Excel or Microsoft Word to make work easier. To create macros, click on „View“ at the top of the Excel menu bar – on the far right you will find the macro area where you can create new macros with the function „Record macro…“. You can define each macro with the following properties:
- Macro name
- Key combination with which you want to trigger the macro
- Save macro in
- Description (optional)
Activating and programming Excel macros
First, the macros in Microsoft Excel must be activated as described above. To programme the individual automated commands, the following steps are still carried out:
- Click on „View“ in the Excel menu bar at the top.
- Create new macros on the right in the macro area with the function „Record macro…“.
- Each individual macro must be defined with certain properties
- Name of the macro
- Key combination that is to activate the macro
- Storage location for the macro
- If desired, description of the macro
Activate Word macros via button
Word macros can be activated not only via a specific key combination, but also via a defined button:
- Go to the „View“ tab in the menu bar and click on the symbol for „Macros“.
- In the context menu, select the middle option „Record macro“.
- Now define the „Macro name“.
- The selection „Save macro in“ offers the option to use the macro in all Word documents by selecting „All documents (Normal.dotm)“.
- Now select the option „Button“ under „Assign Macro“.
- Click on the newly created macro („Normal.NewMacros.MacroName“)
- click „Add“.
- With the „Change“ button, the macro can now be given a symbol and a suitable name.
- Confirm with „OK“.
From now on, the symbol given to the macro appears in the button above the menu bar. If you now want to activate this or several macros, all you have to do is click on the corresponding symbol at the appropriate place in the text.
Header Image: © Gorodenkoff, stock.adobe.com
PowerPoint: Edit the Excel link without problems
PowerPoint: Edit the Excel link without problems
Microsoft Office 2021 or Microsoft 365 contains a lot of practical services that make everyday office life, but also communication and organisation in the private sphere, much easier. Editing texts with Word, creating calculations with Excel or designing presentations with PowerPoint … Some features also make it possible to link the individual programmes with each other. For example, an Excel table can be inserted effortlessly into Word – and just as easily into Microsoft PowerPoint. Here we show how to edit such an Excel link.
Often it is not possible to edit an Excel link because ..
… when inserting an Excel table into Microsoft PowerPoint, the link was not considered in one of the first steps or was executed incorrectly. A link also does not react to changes if the Excel workbook in which the Microsoft Excel table is originally located has been renamed at some point. Another source of error is when the Excel workbook has been moved to another directory within Microsoft 365 or Microsoft Office 2021. In both cases, Microsoft PowerPoint can no longer access the original Microsoft Excel spreadsheet. It simply no longer exists for the programme and it is not possible to update it. Now there is only one thing that helps: Edit the Excel link so that PowerPoint automatically adopts changes to the original Microsoft Excel spreadsheet.
Inserting an Excel table and editing the Excel link
If you want to insert an Excel table into a Microsoft PowerPoint presentation, you should select the function „Insert link“ from the outset. The Excel workbook then automatically takes over the data.
How to insert the Excel table into the PowerPoint slide
Anyone who works a lot with Word and Excel has certainly already successfully mastered the option „Insert Excel table into Word“. In the PowerPoint programme, the procedure for inserting an Excel table is very similar.
- Open the corresponding presentation in Excel PowerPoint.
- Then open the Excel workbook with the table to be inserted.
- Select the table.
- Click the „Start“ tab and navigate to the „Copy“ button.
- Now click on the appropriate place on the Excel PowerPoint slide to be able to paste the Excel table there. Again, open the „Start“ tab and select „Paste“ under „Clipboard“.
Edit Excel link
The above steps can be used to insert the Excel spreadsheet into Microsoft PowerPoint and it is then linked so that changes are automatically applied. However, if the Excel workbook was later renamed or moved, the Excel link must be edited.
- Logically, the PowerPoint presentation whose link is faulty is opened first.
- The „Backstage View“ can be opened via the „File“ tab.
- In the menu that appears, click on „Information“.
- The active PowerPoint slide appears, with various selection options below it.
- Under „Related documents“, click on „Edit links with files“.
- In the „Links“ dialogue window, the command „Change source“ can now be clicked.
- Another dialogue window „Change source“ opens and a list appears with several documents available for selection.
- The correct document must now be selected and the command „Open“ must be given by clicking on it.
- Back in the „Links“ dialogue window, click on „Update now“.
- If the updated link works, the command „Close“ is outlined in blue and can be clicked.
Now you can continue working on the Microsoft PowerPoint slide. After the presentation has been closed and reopened once, the programme has automatically adopted the changes or updates to the Excel spreadsheet.
This is also possible: Create an Excel spreadsheet directly in PowerPoint
Sometimes it is not necessary to first create a table in Excel and then integrate it into a PowerPoint presentation – you can create it directly on a slide.
- Click on the slide in the thumbnail view on which an Excel table is to be created.
- Select the „Insert“ tab and click on the small arrow under „Tables“.
- click on „Insert Excel table“ in the drop-down menu.
- A table appears on the Power-Point slide, which can be edited as usual using Excel’s ribbon.
Header image: © monticellllo, stock.adobe.com
Link Outlook, Word and Excel
Link Outlook, Word and Excel - this is how it works!
In this article we show you how to link Microsoft Outlook, Word and Excel. Whether for private or business use – the Office Suite on the PC facilitates many work processes and enables a clean presentation of a wide variety of documents. Microsoft Word can be used to create formatted texts, Microsoft Excel is the top programme for spreadsheets, calculations and data processing. And finally, Microsoft Outlook is used to manage all e-mails and organise appointments with the help of the integrated calendar.
Linking Word and Excel
In everyday office life, it is often necessary to integrate a table into a Microsoft Word document. This can either be created in the programme itself – or simply linked to a table in Microsoft Excel. To do this, first open the corresponding Excel file. Now mark the table or individual sections of the table and copy them with the keyboard command „CTRL+C“. Then open the Microsoft Word document into which the table or parts of it are to be inserted. Now direct the cursor to the place where the table is to appear. With the keyboard command „CTRL+V“ you can now place it exactly there. The disadvantage, however, is that changes to the table can now only be made with the functions of Microsoft Word. It is more convenient to be able to insert an Excel link into Word. How to link Word with Excel:
- First, select the corresponding table in Microsoft Excel and copy it using the shortcut command.
- In the Microsoft Word document, click on the arrow under „Paste“ in the „Start“ tab and select „Paste contents“ in the drop-down menu.
- In the new window, click on „Insert link“.
- Then select „Microsoft Excel Workbook Object“ in the menu window and confirm with „Ok“.
- Changes that are now made to the table in Microsoft Excel automatically appear in the Microsoft Word document.
Linking Microsoft Outlook with Word and Excel
With a Microsoft account, it is easy to harmonise the functions of all three tools. So not only Excel links can be inserted into Word. But tasks, appointments and changes can also be viewed on different end devices by different employees. The first step is to prepare the toolbar for DeepL access.
- To do this, click with the right mouse button on a symbol in the toolbar.
- Select the option „Customise the toolbar for DeepL access“. A new dialogue box opens (depending on the selected programme in Microsoft Word or Microsoft Excel).
- In the entry „Toolbar for DeepL access“ in the navigation bar in the list field „Select commands“, select the item „Commands not included in the ribbon“.
- Click on „Create Microsoft Outlook task“ in the list and activate it.
One of the advantages of this option is that the document sent via Microsoft Outlook remains on the original PC. Before it is sent, it can be „released“ or „locked“ so that editing by others is prevented or made possible. In this way, tasks can be distributed quickly and without effort by switching programmes. It makes sense to distribute tasks, for example, when working on a Word document or an Excel spreadsheet. And the employee needs to be informed about a current change of deadline, for example. Then this new task does not have to be created in Microsoft Outlook first. Instead, it can be displayed directly in the document being worked on. If there are no other tasks associated with the document, it can be sent to all or individual contacts from the address book in Outlook – without having to change the programme. New recipients can also be added at any time using the table function.
Tip: Working with highlighters in Microsoft Word documents
If several people are working together on a Microsoft Word document, it makes sense to mark particularly important text passages with markers. Such bookmarks make it possible to find certain sections of the text quickly, especially in an extensive document or a shared directory that has been shared with Outlook. Previously uninvolved contacts can then continue to work on these as a task, for example, or make changes.
Header Image: © Prima91, stock.adobe.com