Keyboard Shortcuts

Rose Platform

Shortcut	What it does	Where to use it
shift + enter	runs a module	module
enter	new line (will run as separate visualization in code module)	module
tab	navigate the search menu	search
enter	submit keyword to search	search
backspace/ delete	removes a keyword from search	search
ctrl/ cmd + c	copies the selected text	everywhere
ctrl/ cmd + x	cuts the selected text	everywhere
ctrl/ cmd + v	paste the selected text	everywhere

rose.xl.shortcut.map

Shortcut	What it does	Where to use it
Control+Shift+P	Add file path to active chart in excel	Selected data range (not including dates)
Control+Shift+R	Convert selected excel date to yyyy.mm.dd	Selected date range
Control+Shift+E	Convert selected yyyy.mm.dd dates to excel dates	Selected date range
Control+Shift+S	Create a list from a selected two-dimentional table (unpivot)	?
Control+Shift+C	Calculate selection only	Selected formulas
Control+Shift+N	Fill with #N/A	Selected range
Control+Shift+K	Increase one more decimal (0.0% to 0.00%)	Selected range of numbers
Control+Shift+L	Decrease one more decimal (0.00% to 0.0%)	Selected range of numbers
=to_rosedate(date)	Convert excel date to rose date (take one date only)	Selected date range
=from_rosedate(date)	Convert to excel date from rose date (take one date only)	Selected date range
=avg(values)	Calculate average and ignore #N/A	Selected range
=std(values)	Calculate standard deviation and ignore #N/A	Selected data range
=max_ignore(values)	Calculate maximum value and ignore #N/A	Selected datat range
=min_ignore(values)	Calculate minium value and ignore #N/A	Selected data range
=lastdate(values,dates)	Return last date that has value	Selected date and data ranges
=firstdate(values,dates)	Return first date that has value	Selected date and data ranges
=lastvalue(values,dates)	Return the value of last date	Selected date and data ranges
=firstvalue(values,dates)	Return the value of first date	Selected date and data ranges