How to insert Audio or Sound files in PowerPoint

Inserting well files inwards your PowerPoint presentation tin hand the axe add together a spark to your work. Fortunately, Microsoft Office allows you lot to add well files to PowerPoint presentations. You tin hand the axe add together music, narration, or fifty-fifty well bites, to PowerPoint.

Add Audio to PowerPoint

Firstly, to tape as well as take away heed whatever audio, your PC or Desktop must hold out equipped alongside a well card, microphone, as well as speakers. Then, to add together well files to PowerPoint, you lot volition postulate to

1. Add well from your PC
2. Test Audio
3. Change Playback options, If necessary

1] Add well from your PC or Record Audio

Open Microsoft Office PowerPoint as well as direct ‘Insert’ from the Ribbon menu.

Select ‘Audio’ > ‘Audio on My PC’ if the file is stored on your PC.

Now, inwards the Insert Audio dialog box that opens, navigate to the path where the well file is stored as well as select the well file you lot desire to add.

Hit the ‘Insert’ button.

2] Test Audio

Alternatively, you lot tin hand the axe tape well past times going to ‘Insert’ tab, choosing ‘Audio’ as well as then, selecting ‘Record Audio’.

In the ‘Record Sound’ box that opens, type inwards a cite for your well file, select ‘Record’, as well as and hence speak.

Please banking venture complaint – Your device must direct keep a microphone enabled inwards gild to tape audio.

To review your recording, select Stop as well as and hence select Play.

3] Change Playback options

To house the clip at an appropriate position, motion your clip past times selecting as well as dragging the well icon to where you lot desire it on the slide.

Then, select the well icon as well as direct the Audio Tools Playback tab. Here, you lot tin hand the axe direct keep the activity you lot would similar to take.

For instance, to cut the audio, select Trim as well as and hence purpose the red as well as green sliders to cut the well file accordingly.

To direct how the well file starts, select the dropdown arrow from ‘In Click Sequence’ as well as direct whatever of the next options-

• Automatically: Plays automatically in i lawsuit you lot advance to the slide that the well file is on.
• When Clicked On: Plays well alone when the icon is clicked on.

Hope you lot discovery this tutorial useful.

Source: https://www.thewindowsclub.com/

How to add prefix or suffix to a range of cells in Excel

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel or Excel online, in addition to then this article volition travel helpful. For instance, if nosotros are presented alongside a long listing of names in addition to nosotros postulate to add together a title, nation MD earlier it, how produce nosotros produce it easily?

Add prefix or suffix to all cells inward Excel

How to add together a prefix to multiple (or all) entries across a column

We could occupation 2 functions to add together a prefix to multiple (or all) entries across a column. The start i is using the & operator, in addition to the minute is using the CONCATENATE function.

The formula for the & operator is equally follows:

=”<prefix> “&<cell divulge of start cell>

Where <prefix> is the prefix to travel added in addition to <cell divulge of start cell> is the place of the start jail mobile telephone inward the column to which to recollect to add together the prefix.

Eg. We are creating the listing inward column C. If the start jail mobile telephone inward the column for which nosotros postulate to add together the prefix is A3, in addition to the prefix is TWC, the formula would be:

="TWC "&A3

We would accept to house this formula inward jail mobile telephone C3 since it needs to travel inward the same row equally the start entry which needs the prefix.

Then click anywhere exterior the cell. Now click on the jail mobile telephone again, in addition to it volition highlight the selection to direct to a greater extent than cells inward the same column. Pull the listing downward corresponding to the entries for which yous postulate the suffix.

Hit Enter when done in addition to it volition add together the prefix to every entry inward the intended column.

Alternatively, yous could occupation the CONCATENATE component division for adding the prefix:

=CONCATENATE("<prefix>",<cell divulge of start cell>)

In the representative mentioned above, the component division would become:

=CONCATENATE("TWC ",A3)

How to add together a suffix to multiple (or all) entries across a column

We could occupation 2 functions to add together a suffix to multiple (or all) entries across a column. The start i is using the & operator, in addition to the minute is using the CONCATENATE function.

The physical care for for adding a suffix using the & operator is equally follows:

=<cell divulge of start cell>&"<suffix>"

Where <suffix> is the suffix to travel added in addition to <cell divulge of start cell> is the place of the start jail mobile telephone inward the column to which to recollect to add together the suffix.

Eg. We are creating the listing inward column C. If the start jail mobile telephone inward the column for which nosotros postulate to add together the suffix is A3, in addition to the suffix is pending, the formula would be:

=A3&" pending"

We would accept to house this formula inward jail mobile telephone C3 since it needs to travel inward the same row equally the start entry which needs the suffix.

Click anywhere exterior the jail mobile telephone in addition to and then dorsum on the cell. Pull the formula downward across the column till where yous postulate to add together the suffix for the cells inward the intended column.

Hit Enter when done in addition to it volition add together the suffix to every entry inward the intended column.

Alternatively, yous could occupation the CONCATENATE component division for adding the suffix:

=CONCATENATE(<cell divulge of start cell>,"<suffix>")

In the representative mentioned above, the component division would become:

=CONCATENATE(A3," pending")

Use spaces piece adding the prefix in addition to suffix accordingly.

Hope this helps!

Source: https://www.thewindowsclub.com/

Arrows keys not working in Microsoft Excel

Excel sail is frequently lauded equally 1 of the close utilitarian pieces of software. With the tending of Excel, nosotros tin exercise spreadsheets, squelch numbers too railroad train a concern report. Generally, nosotros press arrow keys to deed from 1 jail cellphone to another. However, sometimes pressing arrow keys volition deed the entire worksheet.

Arrows keys non working inward Excel

Are you lot frustrated that pressing the arrow fundamental is moving the entire spreadsheet instead of a unmarried cell? You are non alone. This is a really mutual occurrence, too inward this article, nosotros volition enjoin you lot how to cook Arrow Keys non working inward Microsoft Office. This detail fault occurs due to unintended take away of Scroll Key. Fret not, inward this article nosotros volition walk you lot through a elementary too slow solution to cook this problem.

1] Disable Scroll Lock

Disabling Scroll Lock key was easy, exactly newer laptops don’t come upward alongside Scroll Lock. If your keyboard doesn’t come upward alongside scroll key, you lot bespeak to press “Fn” too disable the Scroll Lock. That apart you lot tin likewise exercise the on-screen keyboard too plow off the Scroll Lock. The Scroll Lock condition is displayed on the Excel sheet; this volition tending you lot to double check. Additionally, you lot tin exercise SHIFT+F14 to toggle the Scroll Lock to the Off Position.

Follow the steps below to pick out upward the on-screen keyboard:

• Press the Windows Key
• Type on-screen keyboard too press Enter.

Observe the screenshot. The Scroll Lock is inward On seat since the “ScrLk” fundamental is inward blue. Click on the “ScrLk” fundamental to plow off the Scroll Lock. Make certain that the fundamental is non inward blue. As nosotros explained earlier, you lot tin exercise the Scroll Lock indicator inward the condition bar. Meanwhile, you lot tin likewise disable/enable the scroll fundamental yesteryear using the characteristic on Microsoft Excel, equally shown inward the picture below.

2] Turn on the Sticky Key

Disable Scroll Lock didn’t work? Well, campaign this method. Many users pick out reported that the Arrow Keys upshot on Excel is fixed yesteryear enabling Sticky key. Follow the steps below to enable Sticky Key,

• Type Control Panel inward Start Menu
• Click on Control Panel
• Select Turn On Sticky Keys pick too click OK
• Go dorsum too uncheck the Turn On Sticky Keys option

The malfunctioning Arrow keys on Excel should locomote fixed yesteryear now.

The Arrow fundamental non working is a pretty erstwhile Excel annoyance that crops upward for users from fourth dimension to time. I promise our step-by-step guide helped you lot cook the issue.

Source: https://www.thewindowsclub.com/

How to change Ruler unit in Word, Excel, PowerPoint

Microsoft Word uses horizontal together with vertical rulers to align paragraphs, tables, images etc. It is essential non exclusively to accept a layout that suits your agency of writing, only they too receive upward one's hear how the documents become printed. By default, the unit of measurement for these rulers is laid to inches but, you lot tin alter it to a unit of measurement of your pick easily. In this guide, nosotros volition percentage how you lot tin alter the ruler unit of measurement in  Word, Excel together with PowerPoint from inches to cm, mm, points together with picas.

Change ruler unit of measurement inwards Word, Excel, PowerPoint

It industrial plant on whatever Office installation. I tried it amongst Office 365 on my computer. As an example, nosotros volition present you lot ow to produce it inwards Word:

1. Open Word, together with and then click on the File carte du jour together with select Options.
2. In the Word options window, select the Advanced department inwards the left panel.
3. In the right-pane scroll until the Display department is visible to you.
4. When found, select the desired unit from the drop-down listing together with click on ‘OK’.

You tin change the ruler unit of measurement from inches to centimetres, millimetres, points, together with Picas. Points are used when you lot involve to imitate pixels, spell Picas are typically used to stand upward for fixed horizontal measurements.

When you lot wishing to come across how just it volition expect on a physical paper, this is what should travel used. It is used mainly for designing newspapers, magazines, newsletters, together with ads. Picas are 1/6 inch together with incorporate 12 points.

The same applies to whatever Microsoft Office, including Excel, PowerPoint, together with more. The alternative is available nether Advanced > Display section.

Under display section, you lot accept ii to a greater extent than options.

1. Show pixels for HTML features – It is to purpose pixels equally the default unit of measurement of mensuration inwards dialogue boxes that are related to HTML features.
2. Show measurements inwards width of characters is useful when it comes to printing.

When you lot wishing to alter ruler unit of measurement dorsum to the default units of measurement, caput dorsum to the same setting inwards the Office application options window.

Source: https://www.thewindowsclub.com/

How to edit received email in Microsoft Outlook

Microsoft Outlook provides you lot amongst an alternative to edit received emails inward Outlook. The changes you lot brand on the received electronic mail volition last saved locally for your references as well as would non reverberate the alter inward the electronic mail for the sender or the other electronic mail recipients.  In this article, nosotros walk you lot through the steps on how to edit received emails inward Microsoft Outlook using Windows PC.

Emails are an efficient as well as productive agency of transmitting all kinds of data. It is the nearly sought after agency of communication for a lot of companies, line organisation as well as is the go-to medium for a lot of people inward the workplace.

However, sometimes you lot may have an electronic mail amongst a dependent area line which is empty or a dependent area which doesn’t deliver an appropriate description for you lot to position the electronic mail for after use. Most oftentimes an electronic mail message is filled amongst a lot of unwanted texts similar the signatures or a listing of the unneeded addresses as well as information.

In such cases, you lot may desire to accept an alternative that would allow you lot to add together an appropriate dependent area as well as edit the message on a received email. If you lot are looking out for a suitable agency to edit the received email’s subjected line as well as message, you lot are inward the right place.

Edit received Email inward Microsoft Outlook

1. Launch Microsoft Outlook on your computer.
2. In your mailbox, search the electronic mail you lot desire to edit.
3. Double click on the electronic mail to brand changes inward a carve upwards window.
4. Now inward the toolbar ribbon of the mail, become to Move department as well as click the Actions push clitoris from the menu.
5. Select the Edit Message from the drop-down menu. This opens the electronic mail inward editing mode.

Edit a dependent area line of a received message

To edit the dependent area line of the email, click the dependent area champaign on the mail.

Change the dependent area line.                                                                                                         

Click the Save push clitoris on the upper left corner of the Email window.

Edit a text torso of a received message

1. To edit the email’s message, click the torso text below the dependent area line.
2. Edit the message. You tin sack delete the entire message, withdraw unnecessary data, brand corrections or type additional information equally you lot want.
3. Once done, Click the Save push clitoris to apply the changes.

The inward a higher house changes made volition appear exclusively on your mailbox as well as they won’t last reflected on the sender’s electronic mail or whatsoever other recipients.

Source: https://www.thewindowsclub.com/

How to change default font, color, style, and size in Microsoft Outlook

As a Microsoft Outlook user, you lot don’t accept to stick amongst Office’s default gear upwards of Fonts inward your emails or messages. It’s a snap to ‘change default font’ of private messages inward Outlook. Here’s a brusk tutorial explaining you lot customize or alter default font color mode too size inward Microsoft Outlook.

Customize default font & font size inward Outlook

In Outlook, you lot tin shipping away enlarge the default font to cut down chronic optic hurting or resize it to a smaller to jibe to a greater extent than things inward a unmarried window. Most Microsoft apps are customizable to users’ liking too Outlook is no exception to this rule. The personal data managing director from Microsoft is gear upwards to Calibri (11 Pt) every bit the default Font too size.

Customizing the font too the font size inward Outlook tin shipping away hold out done inward a few elementary steps. If you lot accept Microsoft Outlook installed on your PC launch it.

When launched, click on the ‘File’ tab visible nether the Ribbon card too scroll downward to locate ‘Options’

When found, click it.

Now, when the Outlook Options window opens, conduct ‘Mail’ category too striking the ‘Stationery too Fonts’ tab every bit shown inward the icon above.

Here, inward the novel ‘Signatures too Stationery’ window that opens up, you lot tin shipping away configure the fonts, styles, colors, backgrounds section, effects too more.

Click Font nether New postal service messages too select the desired font, style, size, color, too whatever embellishments. I accept chosen Times New Roman every bit the desired font precisely you lot tin shipping away alter it to the 1 that improve suits you.

When done, striking the ‘OK’ button.

In the Signatures too Stationery. windows, you lot did it for New postal service messages. Likewise, create the same for-

• Replying or forwarding messages
• Composing too reading patently text messages.

That’s it!

Related read: How to alter default font inward Word, Excel, PowerPoint.

Source: https://www.thewindowsclub.com/

How to change default font in Word, Excel, PowerPoint for Windows 10

Microsoft Office, a few years dorsum changed the font size too means to Calibri. While it was a expert decision, at that spot are e'er closed to users who produce non similar the defaults too postulate a change. They similar to pick out a font that plant best for them. If you lot are 1 of those users, who wishing to modify the default font too select a 1 that improve suits your needs, too hence this post service volition involvement you.

Change default font inwards Microsoft Office applications

In this tutorial, we’ll present you lot to modify the default font in-

1. Microsoft Office Word
2. Microsoft Office Excel
3. Microsoft Office PowerPoint

If the preset default font inwards Microsoft Office applications bothers you, scroll downwards to read close things to try.

1] Change default font inwards Word

Launch Microsoft Word application click ‘Home’ tab, too and hence click the Dialog Box Launcher arrow inwards the Font group.

Here, click the font you lot wishing to role then, nether ‘Size’, click the size you lot wishing to role for torso text.

Later, striking the ‘Set As Default’ button.

Now, from the dialog box that appears next, click ‘All documents based on the Normal template’ too striking the ‘OK’ push clit twice.

2] Change default font inwards Excel

If you lot would similar to modify the default font for Excel Cells, opened upwards Excel sheet, switch to ‘Home’ tab too select Dialog Box Launcher arrow inwards the Font group.

After that, switch to ‘Font’ tab, select Font, Font Style, Font Size, too striking the ‘Ok button.

3] Change default font inwards PowerPoint

The physical care for for changing the default font inwards Microsoft Office PowerPoint remains the same equally seen inwards Microsoft Word.

Launch PowerPoint application pick out ‘Home’ tab too select the Dialog Box Launcher arrow inwards the Font group.

Next, select the desired font, its size, style, too striking the ‘Ok’ button.

That’s it! This is how inwards few uncomplicated steps you lot modify the default font inwards Microsoft Office applications.

Source: https://www.thewindowsclub.com/