+ Reply to Thread
Results 1 to 5 of 5

Is it possible to do simple excel functions within outlook?

  1. #1
    Registered User
    Join Date
    08-09-2013
    Location
    Central States
    MS-Off Ver
    Office 365 Latest
    Posts
    15

    Is it possible to do simple excel functions within outlook?

    We work with a lot tables that we paste from one email to another, it would be amazing if we could sort or calculate sum easily within outlook when we are drafting an email. Is this possible?
    Also, is there a way to change default table border formatting when we copy table from outlook and paste it into excel? For some reason it's always bold.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Is it possible to do simple excel functions within outlook?

    You can do simple calculations in Word tables (so also in Outlook). See here: https://support.office.com/en-gb/art...d-b2cb2c4f3e27
    You can also sort: https://support.office.com/en-gb/art...6-7C2E48F1D91F

    If you don't want bold borders when you paste into Excel, click the little arrow under the Paste button and select 'Match Destination Formatting'.

    Hope that helps.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    08-09-2013
    Location
    Central States
    MS-Off Ver
    Office 365 Latest
    Posts
    15

    Re: Is it possible to do simple excel functions within outlook?

    I had no idea we could sort/calculate, I will try these, thank you so much.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,426

    Re: Is it possible to do simple excel functions within outlook?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Is it possible to do simple excel functions within outlook?

    You're welcome, glad I could help and thanks for marking the thread as Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Urgently Need A Excel Inventory Sheet With Stock In & Out Very Simple Functions
    By Shubhamjain96 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2018, 08:26 PM
  2. [SOLVED] Excel functions with simple examples
    By Sunny1248 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2016, 12:28 AM
  3. Embed Excel functions into Outlook form template
    By kanep in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 04-27-2015, 03:10 AM
  4. Convert Excel formulas containing functions to a simple form
    By syedalisajjad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2014, 11:39 AM
  5. Certain excel functions in Outlook like paste special or distribute evenly?
    By hyde in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 05-21-2014, 10:29 PM
  6. Simple outlook find
    By marcar in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2013, 11:13 AM
  7. Export simple appointments from Excel to Outlook
    By Kila01 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1