SOLVED

Excel not Inserting new or copied lines

Copper Contributor

20 years of Excel and I've never had this problem before. Excel is not Inserting (new or copied) lines on two separate files I have open.  It is a simple pricing sheet with 10-12 columns (some descriptive, some formulas taking info from 2 or 3 columns in the same line and I want to add several lines of new products above my  Totalizing line.

I've always highlighted 8 lines,, copied and inserted above the top highlighted line. Today it does nothing.  Same if I highlight 8 lines and right click and choose insert lines..  Again nothing.   I assume it must be a SETTING of some sort but cant find anything to lead me to it. 

What is going on? Help

3 Replies
best response confirmed by Tankman268 (Copper Contributor)
Solution

@Tankman268 

It sounds like you might be experiencing a specific issue with Excel, rather than a setting or configuration problem. Here are a few troubleshooting steps you can try to resolve the issue:

  1. Check for Frozen Panes or Filters: Make sure there are no frozen panes or filters applied to the worksheet that might be preventing the insertion of new lines. Try unfreezing any panes and clearing any filters to see if that resolves the issue.
  2. Check for Protection: Ensure that the worksheet or workbook is not protected. If it is, you won't be able to insert new lines. You can check for protection by going to the "Review" tab in the Excel ribbon and looking for the "Protect Sheet" or "Protect Workbook" option.
  3. Check for Hidden Rows: Look for any hidden rows within the worksheet that might be blocking the insertion of new lines. You can unhide rows by selecting the rows around them, right-clicking, and choosing "Unhide."
  4. Try Inserting Rows in a New Worksheet: Create a new worksheet within the same workbook and try inserting rows there. If you're able to insert rows in the new worksheet, the issue might be specific to the original worksheet.
  5. Check for Corrupt Workbook: If the problem persists across multiple worksheets or workbooks, it's possible that the workbook itself is corrupt. Try creating a new workbook and copying the contents of the problematic worksheet into the new workbook to see if that resolves the issue.
  6. Restart Excel: Sometimes, simply closing and reopening Excel can resolve unexpected issues. Close Excel completely and then reopen it to see if the problem persists.

If none of these steps resolve the issue, it's possible that there may be a more complex problem with Excel or your system configuration. In that case, you may need to give more information about this issue. See this link for what information this is: Welcome to your Excel discussion space! The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

@NikolinoDE It appears that a combination of pasting data to a new workbook and then shut down of Excel and restart has finally solved the problem thanks. 

 

Now how to make outlook 24 work as well as outlook 2007.  I cant  get 24 to sync my centurylink.net emails (but discontinued mail did just fine) and find it much less space efficient than the 2007 version on an old laptop.  But I hate having to use two computers  or going to web to do emails.  

@Tankman268 

 I'm glad to hear that the issue with Excel was resolved. Now, let's address your concerns with Outlook and syncing your CenturyLink.net emails.

Syncing CenturyLink.net Emails with Outlook 2021 or Outlook for Microsoft 365

  1. Check Email Account Settings:
    • Ensure you have the correct IMAP/POP and SMTP settings for CenturyLink.net. These settings can typically be found on the CenturyLink support website or by contacting their customer service.
  2. Add CenturyLink.net Email Account to Outlook:
    • Open Outlook.
    • Go to File > Account Settings > Account Settings.
    • Click on New to add a new email account.
    • Select Manual setup or additional server types and click Next.
    • Choose POP or IMAP and click Next.
    • Enter your account details:
      • Your Name: Your Name
      • Email Address: yourname @ centurylink.net
      • Account Type: IMAP or POP (IMAP is recommended)
      • Incoming mail server: mail. centurylink. net
      • Outgoing mail server (SMTP): smtp. centurylink. net
      • Username: yourname @ centurylink. net
      • Password: Your email password
    • Click on More Settings.
    • Go to the Outgoing Server tab and check My outgoing server (SMTP) requires authentication.
    • Select Use same settings as my incoming mail server.
    • Go to the Advanced tab:
      • Incoming server (IMAP): 993 with SSL/TLS or 143 without
      • Outgoing server (SMTP): 587 with STARTTLS
    • Click OK, then Next, and Finish.
  3. Check for Updates:
    • Make sure Outlook and Office are fully updated. Sometimes, issues with email syncing can be resolved with the latest updates.
  4. Check Firewall and Antivirus:
    • Ensure that your firewall or antivirus software is not blocking Outlook from accessing the internet. You may need to add exceptions for Outlook.

Improving Space Efficiency in Outlook

  1. Customize the Ribbon and Quick Access Toolbar:
    • You can customize the ribbon to show only the commands you use frequently, reducing clutter. Go to File > Options > Customize Ribbon to make changes.
  2. Use Compact View:
    • In the View tab, choose Change View and select Compact to make the most of your screen space.
  3. Hide Reading Pane:
    • If you don't use the reading pane, you can hide it to gain more space. Go to View > Reading Pane and select Off.
  4. Clean Up Conversations:
    • Use the Clean Up tool to remove redundant messages in email conversations, which can help reduce inbox clutter.
  5. Archive Old Emails:
    • Archive old emails to reduce the size of your primary mailbox. Go to File > Info > Tools > Clean up old items.
  6. Use Categories and Folders:
    • Organize your emails into categories and folders to make your inbox more manageable.

By following these steps, you should be able to sync your CenturyLink.net emails with Outlook and make the interface more space-efficient and user-friendly. If you continue to experience issues, consider contacting CenturyLink support for assistance with specific email settings.

1 best response

Accepted Solutions
best response confirmed by Tankman268 (Copper Contributor)
Solution

@Tankman268 

It sounds like you might be experiencing a specific issue with Excel, rather than a setting or configuration problem. Here are a few troubleshooting steps you can try to resolve the issue:

  1. Check for Frozen Panes or Filters: Make sure there are no frozen panes or filters applied to the worksheet that might be preventing the insertion of new lines. Try unfreezing any panes and clearing any filters to see if that resolves the issue.
  2. Check for Protection: Ensure that the worksheet or workbook is not protected. If it is, you won't be able to insert new lines. You can check for protection by going to the "Review" tab in the Excel ribbon and looking for the "Protect Sheet" or "Protect Workbook" option.
  3. Check for Hidden Rows: Look for any hidden rows within the worksheet that might be blocking the insertion of new lines. You can unhide rows by selecting the rows around them, right-clicking, and choosing "Unhide."
  4. Try Inserting Rows in a New Worksheet: Create a new worksheet within the same workbook and try inserting rows there. If you're able to insert rows in the new worksheet, the issue might be specific to the original worksheet.
  5. Check for Corrupt Workbook: If the problem persists across multiple worksheets or workbooks, it's possible that the workbook itself is corrupt. Try creating a new workbook and copying the contents of the problematic worksheet into the new workbook to see if that resolves the issue.
  6. Restart Excel: Sometimes, simply closing and reopening Excel can resolve unexpected issues. Close Excel completely and then reopen it to see if the problem persists.

If none of these steps resolve the issue, it's possible that there may be a more complex problem with Excel or your system configuration. In that case, you may need to give more information about this issue. See this link for what information this is: Welcome to your Excel discussion space! The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

View solution in original post