Makros aktivieren in Microsoft Word und Excel

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 with the help of macros either via the mouse or together 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 each 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 Security Centre (Trust Center) section.
  • Click on the button Settings for the Security Centre (Trust Centre Settings).
  • Now go to the section Settings for Macros (Macro Settings).
  • Click on Activate all macros (Activate VBA macros).
  • Confirm the 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 is 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:

  • At the top of the Excel menu bar, click on „View“.
  • On the right in the macro area, create new macros 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

Activating Word macros with a 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“ there.
  • 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 with the selection „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, you only have to click on the corresponding symbol at the corresponding text position.

Header Image: © Gorodenkoff, stock.adobe.com

by Blitzhandel24

Excel Verknüpfung bearbeiten

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. 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 „Close“ command 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 applied 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 PowerPoint slide, which can be edited as usual with the Excel ribbon.

Header image: © monticellllo, stock.adobe.com

by Blitzhandel24

Word und Excel verknüpfen

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 „Insert“ in the „Start“ tab and select „Insert 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 quick access.

  • To do this, right-click on a symbol in the toolbar.
  • Select the option „Customise the quick access toolbar“. A new dialogue box opens (depending on the selected programme in Microsoft Word or Microsoft Excel).
  • In the „Quick Access Toolbar“ entry in the navigation bar, in the „Select Commands“ list field, 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

by Blitzhandel24

Excel Tabelle sortieren

Sort Excel spreadsheet automatically - this is how to do it!

Sort Excel spreadsheet automatically - here's how!

The Excel spreadsheet programme – for example Microsoft Excel 2010 in Microsoft Office 365 – is incredibly versatile. The most important function is probably the creation of tables. But depending on the volume of data, this can quickly become quite confusing. To prevent this, it makes sense to let the programme sort the Excel table. There are various options available, which we will explain in more detail here.

Why should you sort an Excel table?

For a good analysis of data, it is important to be able to sort them in an Excel table. In Microsoft Excel 2010, various sorting options are available, such as sorting Excel rows or sorting Excel columns. A finer sorting of individual data is also possible. For example, data can be sorted by numbers, by date and time, by format or alphabetically in order to visually capture and understand data more quickly and to organise it effectively.

Sort Excel rows

If you want to sort an Excel table, you often start by sorting Excel rows. This can be done easily in just four steps:

  1. In an open Excel document, switch to the „Data“ tab and click on the „Sort“ button.
  2. A new window appears, select „Options“.
  3. Next, click on the option „Sort rows“ under „Alignment“ and then confirm with „OK“.
  4. Under „Column“, select a named column for sorting Excel rows and, if necessary, under „Order“, select which value is to be used for sorting the Excel table. Then press „OK“.

Sort Excel columns

  • First select the range you want Excel to sort.
  • You can now access the sort dialogue via the „Data – Sort“ tab.
  • In the dialogue box „Sort“ in Microsoft Excel 2010, select the option „Data“ in the group „Sort and Filter“.
  • In the „Sort“ window click on „Options“, activate „Sort columns“ in the next dialogue box.
  • In the drop-down menu under „Row“, now select the row according to which Excel should sort the columns and confirm with „OK“.

Sort Excel table alphabetically

If, for example, you are dealing with staff or member lists, you can also sort an Excel table alphabetically for better clarity. The following steps are necessary:

  • Select the table that you want Excel to sort alphabetically. Do not mark the headings of the columns and rows!
  • Select the option „Sort“ in the menu „Data“.
  • In the window, select the column that is to sort the Excel table and click on the corresponding option under „Order“.
  • Confirm with „OK“.

This is also possible: Move Excel table

Normally, Microsoft Excel 2010 takes over all data including formulas and values and formats when rows and columns are moved or copied. However, the cell reference is not adjusted in the case of a formula in the cell – an error message appears in the moved or copied cell. If this happens, the references must be re-entered manually. Otherwise, however, all columns and rows can be easily moved in an Excel table with the following steps. The simplest way:

  • First select the cell, row or column that is to be moved or copied.
  • Now select either „Cut“ or „Copy“ on the „Start“ tab. The key combinations „CTRL+X“ for cutting and „CTRL+C“ for copying are quicker.
  • Click with the right mouse button below or to the right of the new position of a cell or column.
  • To move, click on „Paste cut cells“.
  • To copy, click on „Paste copied cells“. The shortcut via the keys for this is „CTRL+V“.

Moving the Excel table with the mouse

If you prefer to use the mouse to sort the Excel table, proceed as follows:

  • Mark column or row to move or copy
  • Move: Move the cursor to the edge of the selected rows or columns until it turns into a move pointer. Hold the mouse button and drag selected elements to the new position.
  • Copy: Hold down the CTRL key and move the cursor to the edge of the selection. When the copy pointer (white arrow) appears, drag the selection to the new position. It is essential to keep the CTRL key pressed!

Header image: © Yu_photo, stock.adobe.com

by Blitzhandel24

Formeln in Excel

Edit formulas in Excel - easily and without a mouse

Edit formulas in Excel - easily and without a mouse

Microsoft Excel 2010 is one of the most used tools in Microsoft Office 365 for a reason. The spreadsheet program makes it possible to compile formulas in Excel, open up and display data, define predefined concatenations, calculate totals and determine statistical values – simply by entering numbers! Our Excel tips and tricks show how this all works super simply.

First create formulas

To create formulas in Excel that are to carry out calculation tasks, only a few clicks are necessary:

  • First enter the equals sign (=) in the input line.
  • Now enter the combination of row and column of the cells from which values are to be calculated (for example A2-C8).
  • Alternatively, the individual cells can also be clicked.
  • The colon (:) now describes the cell range, while the semicolon (;) separates commands.
  • Clicking on the formula symbol (fx) opens a function menu for selection.

Excel tips and Excel tricks for performing arithmetic operations:

  • Microsoft Excel 2010 represents the basic arithmetic operations with the usual characters +, -, *, /.
  • The order of operations is automatically followed by Microsoft Excel 2010, for example, the dot-before-dash rule.
  • For a different order, simply place a round bracket (()).
  • Powers can be represented with the circumflex character (^)
  • The word „WURZEL()“ allows the square root to be calculated.
  • If the word „SUM()“ is entered, the numbers in the marked cells are added together or subtracted from each other.

Automatically copy formats and formulas in Excel

Copying an Excel formula or transferring it automatically without using the mouse is also very easy. This is necessary, for example, if new data is to be entered below an existing list. However, formats and formulas must exist in at least three list lines before the new line so that the programme can copy the Excel formula. Then the new data initially corresponds to the copied data above it; formulas that are repeated in each line are automatically duplicated. Copy formulas in Excel: In the „Tools“ menu of Microsoft Excel 2010, first call up „Options“. A dialogue box appears in which the box „Extend list format and formulae“ is activated under „Options – Edit“. Now all formatting is automatically applied. If you do not want this, „Extend list format and formulas“ must be deactivated.

Move formulas: It is not only possible to copy formulas in Excel, but also to move them to another place in the document. The references of the cell in the formula are not adjusted. For example, if you move the formula of cells A2-C8 to D2-F8, the formula still refers to the original cells. In practice, this is helpful if, for example, only the result cell is to be placed in a different position, but the references in the formulae are not to be changed.

  • To do this, first enter the corresponding formula and confirm with „Enter“.
  • Now select the cell and choose the key combination „Ctrl + X“.
  • Next, select the cell in which the formula is to be inserted.
  • The key combination „Ctrl + V“ now creates the formula in the new field.

Tip: If the cursor is clicked on the green frame of a cell, a small hand is displayed. With this, the cell can now be dragged to any position.

Editing formulas in Excel without the mouse

Basically, the F2 key can be used to edit the contents of cells in edit mode. When pressed, the arrow keys on the keyboard move the contents of the cell or formula in the desired direction. In addition, Excel marks the cells that are addressed in a formula by highlighting them in colour. The references within a formula are also marked so that errors can be found quickly and at a glance. Tip: The following Excel trick helps so that you don’t have to jump into a cell with F2 every time to check its formula content: Under „Formulas“, select the sub-function „Show formulas“. This will cause the individual formulas themselves to appear in the cells instead of the results. With the arrow keys you can now easily jump back and forth between the cells. The Esc key ensures that the editing mode is then exited again.

Header image: © Araki Illustrations, stock.adobe.com

by Blitzhandel24

Microsoft Office 365 Excel

Linking Word and Excel - Tips and Tricks

Linking Word and Excel - Tips and Tricks

If you want to write and format texts on your PC, Word is definitely the programme of choice. And if you want to create diagrams and carry out calculations, Microsoft Excel is just right. Both are available together in various packages from Microsoft Office. But if you want to insert tables or diagrams from Excel into Word, it can be tedious – an error can quickly creep into the Microsoft Excel source file due to an unclean adjustment. Here we show how this can be prevented.

What Microsoft Excel can do

Basically, Microsoft Excel is a programme specialised in spreadsheets that can be installed on all major devices and operating systems. Its functions in detail:

  • Calculations The most important types of calculations can be performed between several cells and supplemented by known variables.
  • Charts and graphs Numerical tables can be converted into visual data, for example to show results more clearly in a presentation.
  • Calendar Among other things, schedules and recurring events can be managed.
  • Inventory management Lists of inventory and staging points can be used for automatic calculation.
  • Time recording Project hours, employee times etc. are recorded in tabular form and added up in the result.
  • Forms In addition to ready-made selection options, standardised formulas for numerous areas of application can be easily created by the user.
  • E-mail lists Structured lists with all relevant data are suitable for maintaining an overview, for example of newsletter recipients.
  • Data analysis Detailed data records can be downloaded and saved in csv format, among other things.
  • Accounting Expenditure and budget planning, records and forecasts are automatically calculated and updated.

Integrating Microsoft Excel in Word - this is how it works

To functionally link, for example, Microsoft Excel tables with a Word document, several steps are necessary:

  • In the Microsoft Excel document, the relevant table area is first marked and copied to the clipboard.
  • Then it is pasted into the Word document at the point where the table is to appear. If the table has already been created in the correct format, "Link and keep original formatting" must be selected in the insert options. If the table is still to be freely designed, the option "Link and use target format templates" is correct.
  • The tabs "Table design" and "Layout" can be used to adjust the table design.

Microsoft 365

With the subscription service Microsoft 365 subscription service ensures that the latest tools from Microsoft are always available. A distinction is made between Microsoft 365 plans for private use and for companies, educational institutions and non-profit organisations. The plans include the most important Office desktop apps as well as additional online storage and cloud-connected features for real-time file collaboration. The most common for personal use are:

  • Microsoft 365 Family for up to 6 people. Includes AI-powered apps, 1TB of cloud storage per person and advanced security for all your devices.
  • Microsoft 365 Single with the same features as Family, but only for one device.

Included in all versions are Word, Microsoft Excel, PowerPoint,OneNote, Outlook, Access and Publisher.

Microsoft 365 Mac

For Apple users, Microsoft 365 Mac isavailable.Here, too, it is easy to work with Word, Outlook, Microsoft Excel, PowerPoint or OneNote. Microsoft 365 Mac was specially developed to support typical Mac functions such as dark mode, camera transfer in macOS or Touch Bar.

Microsoft Office 2019 - the better choice?

Buy Microsoft Office instead of subscribing? No problem! For this Microsoft Office 2019 has been developed. The Office apps such as Word, Outlook or Microsoft Excel for both PC and Mac are only paid for once. After the purchase, the software can either be installed or the Microsoft Office download function can be used. Disadvantage: No upgrades are included in the purchase. If these are desired later, a new main version of Microsoft Office must be purchased at full price.

Header image: © dennizn, stock.adobe.com

by Blitzhandel24

Excel in Word einfügen

Microsoft Excel - Tabelle in Word einfügen

Microsoft Excel - Tabelle in Word einfügen

Die Microsoft Office Softwarefamilie ist unheimlich vielseitig und bietet genügend Programme, um fast alle Aufgaben im Büro, Schule oder Studium damit zu bearbeiten. Während Outlook und Office die meisten Menschen sehr intensiv nutzen und beherrschen, fristet bei vielen Microsoft Excel eine Art Schattendasein. Das ist sehr schade, denn Excel ist nicht nur ungleichblich praktisch, sondern auch ganz einfach. 

Der Funktionsumfang von Excel ist riesig – immerhin beherrscht das Programm mittlerweile über 400 Funktionen. Die muss natürlich nicht jeder wissen. Die meisten Menschen brauchen Excel wahrscheinlich nur um ein paar grundlegende Arbeiten wie Addition oder Prozentrechnung durchzuführen. Aber selbst für einfache Arbeiten mit Tabellen benutzen zu viele Nutzer Microsoft Word – das hierfür gar nicht ausgelegt ist. Dabei ist es sehr einfach in Excel eine Tabelle anzulegen, den Komfort einer intelligenten Tabelle zu nutzen und diese in Word einzubinden. Wer möchte, kann auch die Excel Tabelle mit einem Word Dokument verknüpfen und so alle Änderungen in der Excel-Tabelle automatisch in Word übernehmen.

So fügt man eine Excel-Tabelle in Word ein

Wer eine Excel-Tabelle in Word einfügen möchte, kann einfach in Excel eine Tabelle erstellen, die Felder markieren, die in Word eingefügt werden sollen, mit der rechten Maustaste auf die markierten Zellen klicken und „Kopieren“ auswählen (oder mit der Tastenkombination STRG+C kopieren).

Anschließend wechselt man in das Word-Dokument, klickt auf die Stelle, wo die Tabelle eingefügt werden soll und wählt „einfügen“ aus (oder fügt den Inhalt mit STRG+V ein).

Standardmäßig wird das Format der Excel-Tabelle in Word übernommen. Wer in Excel nur Werte in Zellen eingetragen hat, der bekommt nur eine Auflistung ohne Tabellenlinien oder farbige Formatierungen. In Excel kann man im Reiter „Start“ im Bereich „Formatvorlagen“ einfach eine Formatierung unter „Als Tabelle formatieren“ auswählen.

So verknüpft man eine Excel-Tabelle in Word

Wer seine Werte und Daten in Word sortiert einfügen möchte, sollte die Tabelle in Excel erstellen und dann in Word einfügen. Denn in Excel kann man mit der Hilfe einer intelligenten Tabelle die Werte beliebig sortieren und systematisieren.

Wenn man einmal die Tabelle in Word eingefügt hat, dann kann man die Tabelle nur noch in Word ändern. Änderungen an der Tabelle in Excel werden dann nicht mehr übernommen. Deswegen ist es sinnvoller die Excel-Tabelle in Word zu verknüpfen.

Um eine Excel-Tabelle mit Word zu verknüpfen, kopiert man zuerst die Inhalte in Excel wie ober beschrieben. In Word fügt man diese allerdings nicht einfach ein. Stattdessen bewegt man den Cursor dorthin, wo man die Tabelle einfügen möchte. Anschließend klickt man auf den kleinen Pfeil unter „Einfügen“ im Reiter „Start“ im Abschnitt „Zwischenablage.“

In dem sich nun öffnenden Drop-Down Menü wählt man die Funktion „Inhalte einfügen“ aus und es öffnet sich ein neues Fenster mit diesem Namen. Hier wählt man die Option „Microsoft Excel-Arbeitsmappe-Objekt“ aus.

Mit einem Klick auf „Ok“ bestätigt man die Auswahl und die Excel-Tabelle wird in das Dokument eingefügt. Wenn man jetzt in der Excel Tabelle etwas ändert, werden die Daten in Word übernommen. Dafür muss man die Änderungen in Excel speichern und Word neu öffnen, damit die Änderungen in Dokument angezeigt werden.

Wer oft Tabellen für seine Arbeit benötigt, kann sich mit dieser praktischen Funktion viel Arbeit sparen.

Header-Bild: © monticellllo, stock.adobe.com

by Blitzhandel24