+ Reply to Thread
Results 1 to 3 of 3

Excel Online Formatting

  1. #1
    Registered User
    Join Date
    09-13-2020
    Location
    Saskatchewan, Canada
    MS-Off Ver
    365
    Posts
    2

    Excel Online Formatting

    I am sharing an Excel online (web based) sheet with co workers. The sheet is used for coordination of equipment, no calculations - text only in cells.
    When double clicking a cell to enter text, the formatting options grey out. We use red and black fonts in each cell.
    When the sheet was first built, this was working fine.

    Also, when opening the sheet in the desktop app, the formatting buttons on the ribbon do not grey out and we are able to select any color combination for fonts.

    Any suggestions on how to fix this issue?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Excel Online Formatting

    ...When double clicking a cell to enter text...

    Why do you need to dble click? When entering (anything) into a cell, if you are already in that cell, you can just start typing, then ENTER (or use an arrow key to enter and move to another cell.

    DBL clicking puts the cell in EDIT mode, maybe thats why you cant see options?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-13-2020
    Location
    Saskatchewan, Canada
    MS-Off Ver
    365
    Posts
    2
    I gave that a try and once I start typing, all the formatting buttons on the ribbon grey out.


    Quote Originally Posted by FDibbins View Post
    ...When double clicking a cell to enter text...

    Why do you need to dble click? When entering (anything) into a cell, if you are already in that cell, you can just start typing, then ENTER (or use an arrow key to enter and move to another cell.

    DBL clicking puts the cell in EDIT mode, maybe thats why you cant see options?

+ 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. [SOLVED] Excel form online response formatting
    By ckserra in forum Office 365
    Replies: 12
    Last Post: 01-17-2019, 03:15 PM
  2. Macro to copy text with formatting into memory to paste into an online documentation
    By pasqui83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2018, 04:56 PM
  3. VBA + Excel Online
    By wladoD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2017, 05:53 AM
  4. Replies: 13
    Last Post: 05-20-2017, 10:44 AM
  5. [SOLVED] Excel 365 online, date formatting problem.
    By Ginge1267 in forum Excel General
    Replies: 5
    Last Post: 02-11-2017, 03:32 PM
  6. Excel online
    By wladoD in forum Excel General
    Replies: 3
    Last Post: 08-28-2014, 11:59 AM
  7. Re: Which are online microsoft excel online course ?
    By sun0flower in forum Excel General
    Replies: 0
    Last Post: 09-18-2012, 05:15 AM

Tags for this Thread

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