If you don’t want to move a chart while changing the width of the cell, you can lock chart position in one Excel worksheet with this guide. Although the graph moves by width and position of cells, you can turn it off.
In Excel, it is simple to insert a Gantt chart or a dynamic chart. However, the problem starts when you include more cells or columns after you insert a chart into a worksheet. By default, Excel moves the graph so that everything becomes visible without overlapping. However, sometimes you may need to correct the position of your existing graph for some reason. If yes, you can follow this tutorial.
How to lock the position of the chart in an Excel worksheet
To lock the position of a chart and prevent it from moving in an Excel worksheet, follow these steps:
Right-click on the existing graphic.
Select the Chart area format in the context menu.
Switch to Size and properties tongue.
Develop Properties.
To select Do not move or dimension with the cells.
Let’s explore these steps in detail.
At the start, you need to insert a graph into your spreadsheet. You can enter any type of graph, be it simple 2D, 3D or something else. After adding a chart to your spreadsheet, you need to right-click on the chart.
Here you have to keep in mind one essential thing. You must right-click on the plotting area. Otherwise, you will not find the option mentioned below.
If you can right-click on the graph correctly, you should see an option called Chart area format.
After clicking on this option, you can find a sign on your right. By default, it should open Fill & Line. Yes
you have to go to the third tab, called Size and properties. After that, expand the Properties menu.
By default, it must be set to Move and size with cells, and this is why your graph moves when you enter a new column or change the width of an existing cell.
To lock the position, you must select Do not move or dimension with the cells option.
That’s all! From now on, your graph will not move even if you change the width of the cell.
I hope this simple tutorial will help you.
Now read: How to create a smooth curve graph in Excel and Google Sheets.
The Outlook app in Windows 10 comes with many new and advanced features and functions. You can create an email, appointment, contact, and task in the Outlook app. In this article, however, we’ll see how to create and write a new email message in the Outlook app, and learn more about the features and functions it has to offer.
How to create a new email in Outlook
Open the Outlook app from the Start menu or just search for the app in the search box.
The Outlook application will open and you will see the ribbon above which will include a variety of functions and features. To create a new email, click on ‘New email’ of ‘Home’ tongue.
A new message window will open like this. At the top, you will see the menu consisting of different tabs such as File, message, insertion, options, text formatting, review and help.
Fill in the appropriate email addresses in the ‘From to’, and “CC” sections. Also fill in the subject of the e-mail message in the ‘Matter’ section.
Then write the body of the email in the space below and see how we can edit and customize it using the features of Outlook.
Features of the “Message” tab
in the Message tab you will see a variety of separate commands in different sections such as Clipboard, basic text, names, include, tags and my templates.
Under Clipboard, you can cut, copy and paste content and use the Format Painter function. Format Painter allows you to apply a particular aspect and style from one selected content to another.
Basic text includes functionality to change the style, size, and color of the font. It provides you with options to bold, italicize and underline your text. You can choose the content alignment – left, center or right; and increase or decrease the shrinkage, which is the space from the margin. You can also create a bulleted list as well as a numbered list for a better visual presentation of your content.
Under Names, you can check and open the names and email addresses saved in the list.
The Include category allows you to attach a file, business card, calendar, email signatures or any other Outlook item.
Under Tags, you can add different tags to emails to set them based on high priority, low priority, and tracking.
My models will show you the models already available and will also allow you to create new models that you can add to your message. Text and images can be included in the templates.
Features of the “Insert” tab
the Insert tab displays different categories called Include, tables, illustrations, links, text and symbols.
Under Include, you can insert or attach a file, business card, calendar, signature, and other such Outlook items.
You can draw or insert a table with the required number of rows and columns. This can help you organize the information and display it in a presentable way. This feature also allows you to insert a Microsoft Excel spreadsheet into the message.
The Illustrations section will help you add or insert images, shapes, icons, different 3D models, graphics, a SmartArt graphic or even a screenshot!
You can add a hyperlink or a bookmark under Links.
The Text section includes parameters related to text, text styles and Word-Art.
You can also insert an equation, symbol or horizontal line from the Symbols section.
Features of the “Options” tab
in the The options tab you can see different sections such as Themes, Display fields, Encrypt, Tracking and More options.
In the Themes section, you can choose a specific theme, fonts, colors and effects for your document to give it the perfect look you want. The color of the document page can also be changed here.
The Show Fields section allows you to add ‘Bcc’. The recipients in the Bcc field will receive the email, but they will not be visible to other recipients.
You can encrypt and set permission on the message to prevent others from forwarding it.
The commands under Tracking allow you to track the status of the message, whether it is received or read by the recipient. You can also add voting buttons here to your message.
Under More options, you will find additional settings for where or in which folder you choose to save your sent items. You will also find an option to not save your sent items and more of these settings.
Features of the ‘Format Text’ tab
in the Format text tab there are a variety of settings related to the font, the font styles and so under various sections such as Clipboard, format, font, paragraph, styles, editing and zoom.
The clipboard includes functions related to copying, cutting, pasting and formatting the painter.
Format settings allow you to format the message in HTML, plain text, or rich text format.
The Font category includes features for changing the font type, size and color. You can change the case of the text. You can bold, italicize and underline the text.
The settings under Paragraph help you adjust line and paragraph spacing, align content, increase or decrease indentation, etc. You can create a numbered list, a bulleted list, and a multi-level list. You can also add or remove borders and change the shading of the selected content.
Styles allow you to modify all styles, fonts, colors, paragraph spacing used in the document. You can choose from the number of style options available here; and also create a new style for the document.
Changing settings helps you find and replace text using advanced search options.
Finally, you can zoom in or out on the desired percentage.
Features of the “Review” tab
in the Review tab you will find the parameters related to Verification, speech, accessibility, perspectives and language.
Under Verification, you will see three important features – Grammar and Spelling, Thesaurus and Word Count. These help you to identify typos or grammatical errors, identical words or synonyms and the number of words.
The read aloud function under Speech reads the text aloud, highlighting it with the reading.
The accessibility feature checks for problems and helps make the document more accessible to users.
Smart search in Insights allows you to get more information about content from other online sources.
Finally, the language settings allow you to translate the content into another language and choose other language preferences.
Features of the “Help” tab
As in the picture, you can see Help me and Tools sections under the Help me tongue.
Here you will find the buttons to contact a Microsoft agent, give your opinion, get help on Microsoft Office, etc.
Features of the “File” tab
File The tab includes settings for saving the file, printing the file, and other additional Outlook options.
This covers all the features of the Outlook app and that way you can create a new email message and customize it as you want using these features.
Google Slides is an alternative Microsoft PowerPoint tool. If you are in the Google ecosystem, it makes sense for you to Google Slides. However, you often have to switch between Google Slide and Microsoft PowerPoint. We like a mixed ecosystem where we end up using both and switching based on customer needs. In this article, we will explain how to convert Google Slide to PowerPoint and vice versa.
Google Drive offers the ability to convert a presentation created in slides to Microsoft PowerPoint, ODP, PDF and even images. Follow these methods to convert one format to another.
Convert Google Slide to PowerPoint
If you received a Google Slide file by email or on disk, the conversion is relatively simple. Google Drive offers a built-in converter that lets you download a Google Slide file in Microsoft PowerPoint format.
There are three ways to convert slides to PowerPoint.
Right-click on the slide, then click download. It will be downloaded as a PPTX file.
The other way to convert is when the slide is open. Click on File menu> Download> Microsoft PowerPoint. That said, there is no way to change or deactivate it. You cannot change the default download format.
The third way is to import the slides into a new or existing Google slide. You can import it from a previously downloaded slide or from the computer. When the import is complete, you will be able to see the thumbnail preview. Select the slides you want to import and be sure to select the option – Original Leep Theme.
Convert PowerPoint to Google Slide
To convert a PowerPoint to a Google slide as soon as you download it, you’ll need to activate a setting in the player. Google will keep the files as is when you download them to the player, but if you want to convert them, open Google Drive, click the Settings icon (cog icon in the menu). Check the box next to the option – Convert imported files to Google Docs editor format.
You should know that the two companies have their own way of managing files. When you convert a PPTX to Google Slides, the formatting may not be the same. So make sure that if you convert to Google Slides format, open it in the online editor and check if everything is online. If the option is not checked, Google Drive treats it like any other file and does nothing.
We hope the message was easy to follow and that you were able to convert Google Slides to PowerPoint and vice versa. You should always check the formatting in the slide after you have converted.
Related reading: How to convert Excel file to PDF using Google Drive.
If after updating your Outlook, you try to start the program and receive the error message; Something is wrong with one of your data files and Outlook should close, this post is intended to help you. In this article, we will suggest the workaround as you can try to alleviate this problem.
When you experience this problem, the following error message appears;
Something is wrong with one of your data files and Outlook should close. Outlook may be able to repair your file. Click OK to run the inbox repair tool.
As noted on the error prompt, once Outlook users click the OK button, the inbox repair tool will launch and guide them through the repair process.
The next step is to restart the computer to apply the fixes and hopefully resolve the issue, but instead, Outlook will display the same error again.
Something is wrong with one of your data files and Outlook should close
If you are facing this issue, you can try the workaround described below to effectively resolve the issue.
The workaround should make Outlook usable again for all users and requires editing the registry by deleting two keys:
LastCorruptStore
PromptRepair
They are linked to the PST document format.
Since this is a registry operation, it is recommended that you back up the registry or create a system restore point as necessary precautionary measures. Once done, you can do the following:
This tutorial will teach you how to protect all or part of your Microsoft Word document using this feature called “Restrict editing“. This function allows you to mark the document as “Read only“ and always allows modifications or changes in selected parts of the document. Restricting the modification locks certain lines or sentences in the document, which may be important or sensitive and, therefore, cannot be modified by anyone. This is how you can protect the content in an MS Word document.
Protect Word Document Using Restrict Editing
Unrestricted portions of the document can be made available to anyone, or you can only authorize certain users to edit or make changes. You can also protect the entire document and make it read-only. Let’s see how it can be done.
To start, open the MS Word document and click on the ‘Review’ tongue.
Select the sentences to which you do not want the change restriction function to be applied. In this case, I selected sentences 1 and 2 only. in the Review tongue, ‘Protect’ group click “Restrict modification” as shown in the picture.
The Restrict Editing dialog box opens. You will see the following:
Formatting restrictions
Modification of restrictions
Exceptions
Start the application
1]Formatting restrictions
This setting limits formatting to a certain selection of formats or styles. You can select the styles you want to allow in the document. To apply this, check the box.
2]Modification of restrictions
Under Edit Restrictions, check the box that says – Only allow this type of change in the document.
In addition, click on the drop-down menu and choose the option “No changes (read only)”. The document becomes read-only, except for the selected parts. You can also choose other options such as tracked changes, comments, and filling in forms, depending on the changes you want to allow.
Exceptions (optional)
This section allows you to choose the users who can freely edit the document. To allow anyone and everyone to edit the selected part of the document, select ‘Everyone’ check box. You can also enter user names separately, separated by a semicolon.
3]Start application
To apply all of these settings to your MS Word document, click “Yes, start applying protection”.
the “Start applying protection” The dialog opens. You will see two methods of protection – Password and User authentication. Select the ‘Password’ Protection method and enter and re-enter the password generated in the boxes provided. hurry OKAY.
To encrypt the MS Word document, so that only the authenticated owners of the document can remove the protection, click ‘User authentication’.
Advice:
Use strong passwords involving a combination of upper and lower case letters, letters, numbers and symbols.
Make sure you save the password securely in a safe place. If you forget the password, you will not be able to recover it.
Document encryption prevents other users from working on the document at the same time.
How to unlock the protected Word document
To remove all protection from the document, click on the “Stop Protection” button. If you are prompted for the password, enter it.
Note: To remove any protection from the document, you must know the password that was applied to the document. Or, you will need to be listed as the authenticated owner of the document. Do this, click on the Revision tab> Restrict modification> Stop protection.
This way you can protect your MS Word document by using the “Restrict modification” in the Review tab.
There are so many events and occasions in a year that require our time, money and patience. Events and occasions such as birthdays, anniversaries, graduation ceremonies, baby showers, fathers and mothers day and much more. Certain events and occasions may occur at a set time, and some may occur suddenly or have been forgotten. It is necessary to find gift ideas or stationery to meet the requirements of these events and occasions. Well don’t worry, Microsoft I sone company that has it all covered, and it doesn’t have to be expensive. Let’s see how to use Microsoft Office, and to be more specific, Microsoft Publisher to meet some of these needs.
How to Create a Monthly Calendar in Publisher
Microsoft Publisher is a versatile publishing application that can be used to create a wide range of elements. Some of them can be intended for professional use or simply for personal events and a gift solution. Here are some of the things you can use to create personal events and gift solutions.
Business cards
Coupons
Gift cards
Labels
Keywords
Personalized calendar
And more
Let’s see how to use Microsoft Publisher to create a personalized calendar. The calendars are generally the same in most places, they show the year in 12 months. Calendars sometimes have other features, but they are just to show the year. Calendars can however be personalized and they do not have to be very expensive. This is where Microsoft Publisher comes up with many options and economical ways to create custom calendars.
Here are some things you need to make this personalized calendar in Microsoft Publisher.
Know the purpose of the calendar
Gather items and scan if you haven’t already
Decide on delivery method
Create the impressive Microsoft Publisher calendar
Impression
Conclusion
Let’s explore the steps to create this great calendar in Microsoft Publisher.
1]Know the purpose of the calendar
Knowing the purpose of the calendar will make it easier to design the right calendar. Who is the calendar for? What is it used for? Is it a functional calendar or simply for decorative purposes? Is it for professional purposes, for a birthday, for your other half, your family or a friend? When the goal is decided, the choice of font, color, images and style will be much easier. Functional calendars are excellent because they bring back memory while having a useful purpose. These super publisher calendars can be used as an advertising element given to customers.
2]Gather items and scan if you haven’t already
To make this Microsoft Publisher calendar great, custom items will be added. Whether for professional purposes or for a friend, elements can be added to personalize the calendar. You can add photos of the person, photos of achievements, photos of baby, family and much more. Some of them will have to be scanned by scanning if they are on paper or photographed. Some will have to be modified to make them more beautiful or to fit them in a space. Achievements and awards must be photographed and modified to fit.
3]Decide on delivery method
The delivery methods of this calendar once completed are numerous. You can choose to make a monthly calendar with a photo and print it on a mug. Delivery methods can be paper, fabric or other printable material, or they can be kept as a digital copy and sent by email. If you are a secretary or personal assistant, you can choose to make your boss a personalized calendar and add a calendar of their events to it. It can be the same for your calendar. Portfolio size calendars are great for advertising purposes. There may be a calendar on one side and business information on the other.
4]Create the impressive Microsoft Publisher calendar
Go start then click on the Microsoft Office 365 app icon
From this icon screen, click on the Microsoft Publisher icon.
On this screen, you can choose your paper size. To see the calendar option, click more model.
You can choose to search for templates in Office online by clicking Office or click Integrated to use templates saved on your computer.
Of Integrated you scroll down and choose the calendar. You will notice that there are many other things that you can create for your next project.
From this screen, you can choose to Full page calendar or scroll down and choose the Portfolio size calendar. You can also choose the design. On the right, you can choose the Color scheme or leave it by default.
You can also choose the police model or leave it on the default. You can choose to enter your personal or professional information. You can then choose the paper orientation landscape or portrait.
You can then choose one months per page or one year per page. You can also choose to add a calendar of events to your calendar. Whatever choices you make here will affect Full page where the Portfolio size calendar. When these are all defined, simply click on Create.
You can click set calendar dates so you can enter your dates. If you choose the month per page, it will display the list of months and the year to choose. If you choose the year by page, it will display from January to December grayed out and you will simply choose the year.
The calendar can be further modified by adding your personal photo to replace the default photo if it is in the design you have chosen. You can choose to add colors, WordArt and any other enhancements you want. Do not be limited by the templates, many options are available in Microsoft Office Publisher to further customize the calendar.
5]Impression
These Microsoft Publisher super calendars can be printed on any available medium or saved in PDF format and sent by email or on social networks. Calendars can become memories that anyone will love to keep. The calendar can be made in wallet format, printed on PVC, perforated and an added key chain and will be a souvenir. Monthly calendars can be created to celebrate a birthday, anniversary or printed on a mug. These awesome calendars can also be simply printed from any print and used immediately.
Microsoft Publisher is versatile software that can be used to perform many tasks, personally and professionally. Calendars are just a few examples of what can be done using Microsoft Publisher. Calendars can be a great way to celebrate events and occasions. Microsoft Publisher calendars can be used for birthday gifts, baby shower gifts, promotional items and more. Use your imagination and be creative when you create impressive calendars with Microsoft Publisher.
Read next: How to create a business card using Microsoft Publisher.
If you want to recover the Panoramic hand appear in Microsoft office applications such as Word, this guide will show you how to activate and use Panning Hand in Microsoft Office applications, so you can scroll through the pages differently.
Panning Hand function in Microsoft Office applications
Typically, you can scroll down or up with the scroll wheel on your mouse, or you can use the scroll bar on the right side of your screen. However, if you want to use a different method to scroll up, down, right and left in Word or other applications, Panning Hand can do the work for you.
By activating this function, you can see a hand-like icon on your screen. Later, you can use the hand icon as the mouse cursor, click somewhere, and move your mouse up or down to scroll the page accordingly.
For some people, this panoramic hand feature seems cumbersome and time consuming. However, it gained popularity in the old version of Microsoft Office. Therefore, if you want to recover it, you need to follow this tutorial.
Note: We used the Word screenshot in this tutorial. However, you can use the same steps to find the functionality in other applications, if available.
Enable pan hand in Microsoft Office applications
To activate Panning Hand in Microsoft Office applications, follow these steps:
Open Word on your computer.
Click it Customize the quick access toolbar button.
Select the No more orders option.
To select Ribbon missing order from the drop-down list.
Find Panoramic hand and select it.
Click it Add button.
Click it Okay button to save.
Click the new Panning Hand icon to activate and scroll.
To learn more about these steps, keep reading.
At first, you need to open Word on your computer. Since, by default, the Panoramic main option is not activated, you must activate it.
To do this, click on the Customize the quick access toolbar icon visible in the ribbon. After that select No more orders from the list.
You should now extend the Choose commands in drop down list and select Ribbon missing commands option.
Then find out Panoramic hand in the list, select it and click on the Add button.
Now it should be visible on the right side. If yes, you can click on the Okay to save the change. Next, a new icon (Pan Hand) should appear in the ribbon.
If you want to use it, you must activate it first. To do this, click on this icon so that you can see the hand-shaped icon on your screen.
Now you can click somewhere and move your mouse up or down to scroll through the pages.
To deactivate the Panning Hand function, simply cancel the steps mentioned above.
That’s all! I hope this tutorial will help you.
Now read: How to enable Edit Text in Print Preview for Microsoft Word
Microsoft PowerPoint in Windows 10 comes with a variety of different online templates and themes that can make your presentation absolutely beautiful and presentable to your audience. A PowerPoint template or theme consists of slides or a group of slides with unique layouts, fonts, colors, design, effects, background options, etc. Choosing the right theme or template for your PowerPoint presentation, especially for business or work meetings, can send a strong and persuasive message about the brand and brand values to the target audience.
In this article, we will learn how to search for templates and themes online in PowerPoint.
Find PowerPoint Templates and Themes Online
To open the PowerPoint app in Windows 10, click Start> Microsoft Office> PowerPoint. The PowerPoint application will open.
Once you open PowerPoint, click on the ‘New’ in the left pane. You will see a search box called “Search for models and themes online”. Type the keyword or phrase you are looking for in the search box, then press Enter.
Below the search field you will see the suggested searches, for example, presentations, business, education, graphs, diagrams, etc. This is just for reference.
Suppose you are looking for a theme or template that fits your business. Browse the available options by typing ‘Company’ in the search area. Let’s say you want to go with “Bright commercial presentation”.
Once you have chosen the model or theme that you liked, select it and click on ‘Create’. The selected theme or template will be downloaded and ready to use.
You can now start working on your presentation!
Another way to choose or switch to an online theme or template is to ‘File’ menu.
As you can see in the image, a blank presentation is open. Click on the ‘File’ then further click on ‘New’ in the left pane.
Follow the same steps as mentioned above, then select and download the desired template or theme of your choice.
It is advisable to opt for an already existing theme or template for your PowerPoint presentation when you want a ready format or a layout of carefully chosen elements that would bring out the best in the presentation.
With a few simple steps, you can create an attractive PowerPoint presentation in Windows 10.
Similar article: Download Word, Excel, PowerPoint, Access and Visio templates for free.
Excel in Office 365 is a very versatile application. The built-in functionality of Excel makes it the cornerstone of many projects. While we cannot predict or avoid all disasters, our response to these disasters can make a big difference. Our response to disasters is closely linked to our planning and preparation. An important tool in disaster preparedness is a Floor plan showing evacuation routes and emergency numbers. Microsoft Office 365 Excel can help you prepare your family or even your workplace for any eventuality. Microsoft Office 365 Excel has some features that will allow anyone with even basic skills to create a Floor plan showing escape routes.
Microsoft Office 365 Excel can also be used to make floor plans for room organization, seating arrangements and much more. With the built-in calculation function, you will be able to view the floor plan and make calculations if the plan is for the seats.
How to Create a Floor Plan Using Excel
Creating the floor plan with Office 365 Excel requires following these steps:
Memorize or get the map of the region
Draft on paper
Get a mouse instead of using the touchpad
Remember where all the entrance stairs are
Go paper to Microsoft Office 365 Excel.
Let us show you how to create a Floor plan using Excel.
There may be a time when you want to make a floor plan, arrange seating or organize a room. You may have a limited budget, so you can’t get the software to do the job. You can have the skills to do the layout, so you don’t need to hire a professional. Well, you already have the perfect tools, Microsoft Office 365 Excel, your creativity and your skills, and the time.
1]Memorize or get the map of the region
Review the space a few times to get a mental picture of the layout. You can walk with a pencil and paper to sketch the space for which you want the plan. Take note of the important points you need to remember. If this is a floor plan for the emergency route, you may want to note the stairs, elevators, fire extinguishers, etc. after the sketch, try to follow the plan on paper and see if it corresponds to the space. The same goes for the floor plans for the emergency route, the seating arrangement or the space to be designed / decorated.
2]Draft on paper
Drafting on paper is important because it will help you remember. When you go to design in Excel, you may think you remember it, but you may miss important details. The draft will also give you an idea if you are on the right track when you compare to Excel.
3]Get a mouse instead of using the touchpad
If you’re using a laptop, it’s best to use a wired or wireless mouse instead of the touchpad. An external mouse will provide more comfort and precision. You can get a simple, affordable mouse or opt for a sophisticated mouse. Whichever you choose, the external mouse will make the design in Excel more comfortable and more precise.
5]Go from paper to Microsoft Office 365 Excel
Now let’s get to the fun part of formatting in Microsoft Office 365 Excel. Excel is made up of grids. These grids help make it more precise when you’re trying to align things perfectly. These grids can be difficult to work around when you need to create curves in a design, but a little creativity, imagination, and some Excel functionality will help.
If your design has functionality on all sides, it’s best to fit it in the middle of the Excel sheet. Make sure the start is correct, otherwise it will affect the rest of the design. Corrections can take a long time. Choose the area and start with the general shape of the structure or space you want to design.
Microsoft Excel Borders drop-down menu
You will use thick borders to show the walls or main borders. Thinner borders can be used to show interior walls and partitions, and dotted lines to show doors. Other functions can be represented by your choice of articles. Make sure to include a key so people understand.
Drop-down list of Microsoft Office Excel shape options
Shapes are extremely useful when features cannot be created with grids. Shapes such as lines, arcs, squares, etc. Shapes can be used to represent objects such as tables, also used to represent curved areas of the plane and accesses.
Floor plan designed with Microsoft Office Excel
The finished floor plan with all rooms in place using the various features of Microsoft Excel. The grid lines are still displayed in Microsoft Excel. The grid lines will not be printed by default, they will have to be defined. In the print segment, you will be shown how to print the grid.
Floor plan designed with Microsoft Office Excel without grid
A floor plan, a room plan or any other finished plan must be clear and precise. Anyone reading the floor plan should be able to see what needs to be done. Microsoft Office 365 Excel makes the floor plan clear and easy to read.
Printing your floor plan in Excel
Print area option set for Microsoft Office Excel
The first step before printing is to see the number of sheets on which the floor plan is located. Create a print area to eliminate wasted paper. The printing area would be the section with the floor plan and information.
To define the print area, select the areas you want to include, go to Layout, Click on Printing area, then click Define the print area. If you decide to change or delete the print area, go to Layout, Click on Printing area, then click Clear print area
Microsoft Office Excel print grid option
The paper size can be changed to facilitate a larger plan on a single sheet. Margins could also be changed to fit the floor plan on one sheet. You can choose to keep the grid lines in the final print or make the print clear with only the lines of the floor plan. To print the grid, go to Layout then go to Grid line and select Impression.
Microsoft Office 365 Excel, like other Microsoft Office applications, is very versatile. They can do a lot more than you can imagine. It is extremely easy to navigate in Excel to create Floor plans and any other plan. Microsoft Office 365 Excel is an application to consider for simple and economical plan designs. It requires little or no technical skills and anyone familiar with Microsoft Office 365 and Excel can use it to create a floor plan.
Read more: How to use the TRUNC function in Microsoft Excel.
Setting up and updating task progress in Microsoft Planner doesn’t have to be a complex process. You just assign them to the right people and then check their status if necessary. This short guide will guide you through the definition process and update task progress in Microsoft Planner.
Configure and update task progress in Microsoft Planner
Microsoft Planner is a simple and lightweight scheduling tool included in most Office 365 packages. Its main purpose is to provide easy and visual management of tasks to a group of users. For people who want a heavier planning tool, there is another program called Microsoft project.
In Planner, you can set and update task progress by simply assigning labels such as,
Not started yet
In progress (indicated by a half-filled circle)
Done (indicated by a clipart check mark)
Here’s how.
To get started, go to Groups> Progress.
For the tasks in progress, choose another status (In progress).
For completed tasks, access the Progress drop-down list.
Select the “Done” option.
When finished, a check mark will appear next to the Done option.
Please note that completed tasks are hidden at the bottom of the task list.
Each plan has its own table, where you can organize tasks into compartments. Go to your calendar, select “By group’>‘Progress“
Start dragging tasks between columns to quickly update your plan on the fly.
For tasks included in the “In progress“, You can choose to modify the state by selecting the” In progress “symbol visible on the task and choosing another state.
To instantly mark any of your tasks as “Completed“, Point to the task and check the box.
Likewise, you can also update the progress of the task by clicking on the task itself and accessing the Progress drop-down list.
Note – If you are not using a mouse, you will not see the check box to mark something as finished.
If you are not familiar with the process of creating a task in the scheduler, see how it is done.
Launch Planner and select +. Give the task a name. To set the due date, select a date.
Then assign and select a team member.
Select ‘Add a task“
That’s it!
If you’re interested, this post will show you how to create a plan in Microsoft Planner. Creating a plan in Microsoft Planner automatically creates a new Office 365 group, which makes it easier for you to collaborate not only in Planner, but also in other Microsoft applications such as OneNote, Outlook, OneDrive, and others.
If you try to download or sync files to your Mac computer via OneDrive cloud storage and you receive You synchronize another account error, here is the fix you should follow. It is quite easy to get rid of this problem, since you need to delete the saved password from the old keychain access account. This article shows the exact steps to do so.
If you’re using two OneDrive accounts on your Mac computer, you may get this error message when OneDrive can’t properly differentiate the two accounts. This can happen due to internal file corruption. When this message appears, synchronization stops automatically and users cannot upload new files to OneDrive storage.
You sync a different OneDrive account error on Mac
To resolve this problem:
Press Cmd + Space on your computer.
Search access to the keychain.
Open the corresponding application on Mac.
Search OneDrive cached credentials or OneDrive standalone cached credentials.
Right click on it.
To select Remove
Confirm the removal of this password.
Open OneDrive to sign in to your account.
Let’s take a closer look at these steps.
At first, you need to open the keychain on your computer. You can follow any method to do this. However, it’s easy to open this app using Spotlight search. To do this, press the key Cmd + Space buttons together and look for access to the keychain. You should find the app in the results as you type.
After opening the keychain, you should find either OneDrive cached credentials or OneDrive standalone cached credentials.
If you installed OneDrive with Word, Excel, PowerPoint, etc., you should see OneDrive cached credentials.
However, if you only installed OneDrive on your Mac computer, you should see OneDrive standalone cached credentials.
In any case, you must right click on it and select the Remove option.
It will ask you to confirm the deletion. You can confirm this in the pop-up window.
After successfully completing the last step, you can open the OneDrive app on your Mac computer and try to sign into your account. Now you should no longer display an error message and you can download files as usual.
I hope this tutorial will help you.
For your information, the same problem also appears on the Windows computer. If so, you can correct You sync another account error in OneDrive for Windows using this tutorial.
Related reading: You are already syncing this account – OneDrive for Mac error
It does not seem possible to automatically play music in the background when viewing the entire Sway. However, the Microsoft service allows you to add audio cards containing specific audio files. In today’s article, we will introduce you to the method for add media files in Microsoft Sway.
Add video and audio files to Microsoft Sway
In addition to adding audio files to Sway In several common audio formats (such as .mp3 and .wav), you can record audio and upload it to Sway. Either way, you can get the result you want and give your audience an even richer multimedia experience.
Click on Insert content button.
Switch to Media tongue.
To choose audio and add an audio file.
To add an audio recording, click on Record on the audio card.
Record the audio in Sway.
Add video files to Sway.
Here is the detailed description of the above steps.
Add audio to Sway
Open your Sway content presentation and click “Insert content‘button.
Switch to ‘Media“And select”audio»In the list of options displayed.
Now click on the ‘Add audio file»To search for the audio clip on your device.
Wait for the audio file to be processed and added to Sway.
Similar to audio files, audio recordings can enhance your Sway experience. This can make the presentation more interactive and attractive.
Record audio in Sway
To record audio, click “Record’(Microphone icon) on the audio card.
After a three-second countdown, the flashing button appears. This indicates that you are saving.
Click the flashing button when you have finished recording and press the “to play»To preview your recording.
If you are satisfied with your registration, select “Add to Sway»Or choose«Re-register“To start recording again. You can delete your recording by clicking on the “Trash can“
Add video files to Sway
As seen above, you can choose to add video files to Microsoft Sway.
Click on ‘Insert content“And select”MediaThe “tab.
From the list of options displayed, choose “Video“
In the Suggested window, choose ‘My deviceAnd go to the location of the file on your device and select it.
Wait for the file to be processed and successfully added to Sway.
That’s it!
Now read: How to add OneNote images and Web integrations in Office Sway.