+ Reply to Thread
Results 1 to 5 of 5

Shortcut Keys in Excel Ctrl + Shift + N, Ctrl + Shift + R, Ctrl + Shift + U is not working

  1. #1
    Registered User
    Join Date
    07-11-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    8

    Shortcut Keys in Excel Ctrl + Shift + N, Ctrl + Shift + R, Ctrl + Shift + U is not working

    hi,

    Some Shortcut key in Excel is not working after changing my system.

    Ctrl + Shift + N :- to fill blank cells in Selected area to 'Zero'
    Ctrl + Shift + R :- to open dialog box with round-off key prompting for decimal insertion in Selected area
    Ctrl + Shift + U :- Upper case in Selected area

    Need help in keyboarding setting or Excel version or other may be

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Shortcut Keys in Excel Ctrl + Shift + N, Ctrl + Shift + R, Ctrl + Shift + U is not wor

    Those a shortcuts defined in macro procedures.
    Use workbooks that use them and check is still set same shortcut.

  3. #3
    Registered User
    Join Date
    07-11-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    8

    Append and Store data in Power Query

    Hi, I want solution in Power Query. I wanted to append and keep rolling data in same master file on daily basis. Currently when I refresh PQ, it only appends current day's data, yesterday's data is overwritten. Please advice.
    Thanks!

  4. #4
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    2,994

    Re: Append and Store data in Power Query

    What do you mean, append means add to. How can you append and overwrite. Why not attach a sample file to show what you want as per the yellow banner

    Quote Originally Posted by anay_zinje View Post
    I wanted to append and keep rolling data in same master file on daily basis. Currently when I refresh PQ, it only appends current day's data, yesterday's data is overwritten.
    Thanks!

  5. #5
    Registered User
    Join Date
    07-11-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    8

    Re: Append and Store data in Power Query

    See attached power query sample file for append query.
    Attached Files Attached Files

+ 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. Excel 2013 number formatting shortcut CTRL SHIFT 1
    By asharaiha in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2015, 06:33 AM
  2. Excel 2013 number formatting shortcut CTRL SHIFT 1
    By asharaiha in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-08-2015, 05:43 AM
  3. Replies: 6
    Last Post: 05-26-2015, 10:50 AM
  4. ctrl shift 6 shortcut - change the format you get?
    By Bower91 in forum Excel General
    Replies: 2
    Last Post: 11-20-2014, 05:23 AM
  5. [SOLVED] Assigning a shortcut to ctrl and shift and the number pad
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-18-2014, 04:48 PM
  6. Ctrl Shift | Macro Stops | Creating Short Cut Keys
    By gduron in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-06-2006, 06:25 PM
  7. [SOLVED] Macro's with Ctrl or Ctrl-Shift?
    By Al Franz in forum Excel General
    Replies: 6
    Last Post: 09-05-2005, 06:05 PM

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