The step by step video to find out the duplicate value in Kingsoft Office Excel 2013.
Developer(s) | Kingsoft |
---|---|
Initial release | 1988; 33 years ago |
Stable release | WPS Office for Windows (v.11.2.0.10101) / April 23, 2021; 3 days ago |
Written in | CodeGear Delphi, C/C++ |
Platform | Microsoft Windows, Android, iOS, Linux[1] |
Available in | Chinese, English, French, German, Italian, Japanese, Polish, Portuguese, Russian, Spanish, Vietnamese |
Type | Office suite |
License | Proprietary
|
Website | wps.com |
WPS Office (an acronym for Writer, Presentation and Spreadsheets,[2] previously known as Kingsoft Office) is an office suite for Microsoft Windows, macOS, Linux,[1]iOS[3] and Android,[4] developed by Zhuhai-based Chinese software developer Kingsoft. WPS Office is made up of three primary components: WPS Writer, WPS Presentation, and WPS Spreadsheet.[5]
File in WPS's xls format, the other office software (MS, Libre.) cannot open it. I feel cheated buying this office. My attempt to get technical assistant by contacting them was fruitless. Do not buy this product especially if you do lots of data mathematical processing. Kingsoft Office Software WPS Office 10 Business Edition. Is 'NOT' worth it. WPS Office - Free Office Suite for Word, PDF, Excel is an all-in-one office suite integrates Word, PDF, Excel, PowerPoint, Forms, as well as Cloud Storage, Template Gallery, and Online Editing &. Kingsoft Spreadsheets 2009 can convert any Microsoft Excel 2000/XP/2003/2007 workbook (XLS, XLSX, CSV and DBF) into an Adobe PDF file while preserving metadata and hyperlinks. The native PDF export function allows you to specify what parts of the workbook you wish to export into PDF. Open existing Microsoft Excel workbook and Export to PDF. A huge bonus is Kingsoft’s free Mobile Office app that allows you to work with Word, PowerPoint and Excel documents right on your Android device (an iOS version is on the way). Bottom line: If you’re tired of handing over big bucks to Microsoft every time they decide you need an “upgrade”, why not give Kingsoft Office a try?
The personal basic version is free to use. A fully featured professional-grade version is also available for a subscription fee. WPS Office 2016 was released in 2016.[6] As of 2019, the Linux version is developed and supported by a volunteer community rather than Kingsoft itself.[7]
By 2019, WPS Office reached a number of more than 310 million monthly active users.[8]
The product has had a long history of development in China under the name 'WPS' and 'WPS Office'. For a time, Kingsoft branded the suite as 'KSOffice' in an attempt to gain an international market foothold, but later returned to 'WPS Office'. Since WPS Office 2005 the user interface is similar to that of Microsoft Office products, and supports Microsoft document formats besides native Kingsoft formats.
History[edit]
Origins[edit]
WPS Office was initially known as Super-WPS文字处理系统 (Super-WPS Word Processing System, then known simply as WPS) in 1988 as a word processor that ran on DOS systems and sold by then-Hong KongKingsun COMPUTER CO. LTD. It was the first Chinese-language word processor designed and developed for the mainland Chinese market[citation needed]. WPS was used from the late 1980s.
Early history[edit]
Faced with competition from Microsoft Office, Kingsoft chief software architect Pak Kwan Kau (求伯君) diverted 4 million Renminbi from his personal account to assist in the development of WPS 97 for Microsoft Windows. In 1997, WPS 97 was released. The next version, WPS 2000, was released two years later. Both products were developed for a 16-bit Windows platform, with the capability of running on 32-bit Windows platforms.
In May 2001, Kingsoft launched a full office suite under the name WPS Office 2001, which contained a word processor together with spreadsheet and presentation applications. With WPS Office 2001, Kingsoft entered the office productivity market in the People's Republic of China.
In 2002, WPS Office 2002 was released, adding an email client to the office suite. WPS Office 2002 aimed to maintain interface compatibility with established office products.
In 2003, WPS Office 2003 was released. The Chinese government made Kingsoft office software the standard for various divisions of the government.
The 2004 incarnation of the office suite, dubbed WPS Office Storm, was released in late 2004. It claimed to offer total backward compatibility with Microsoft Office file formats. Unlike previous versions, WPS Storm was based on OpenOffice.org and was the first WPS Office suite to support operating systems other than Microsoft Windows. Kingsoft collaborated with Intel and IBM to integrate its text-to-text and text-to-speech technology into WPS Office Storm.
In late 2005, WPS Office 2005 was released with a revamped interface and a smaller file size. Besides the Professional edition, a free Simplified Chinese edition was offered for students and home users. A Wine-hosted edition was provided for Linux users of WPS Office Storm.
In 2007, Kingsoft Office 2007 was released. This was the first version that tried to enter international markets, with support for the English and Japanese languages. The native Chinese-language version continued under the name WPS Office.
In 2009, Kingsoft Office 2009 was released. It had increased compatibility with Microsoft Office including support for the newer 2007-version file formats.
Free Kingsoft Office
In 2010, Kingsoft Office 2010 was released.
In 2011, Kingsoft Office was granted funding from the Chinese government[9] and received further orders from central ministries in China.[10]
Kingsoft Office Suite Free 2012 was released in 2011. Kingsoft Office Professional 2012 and Kingsoft Office Standard 2012 were released for sale in February 2012,[11] in addition to Kingsoft Office for Android.[12] The initial release for Android included standard word processor functions such as creating documents, spreadsheets, and presentations.
On 28 March 2012 Kingsoft announced that WPS for Linux was under development. It is the third WPS Linux product, following WPS Storm and WPS 2005. It was developed from scratch, based on the Qt framework, as compatible as possible with its Windows counterpart.
The free and paid versions of Kingsoft Office 2013 were released on 4 June 2013. They consist of three programs: Writer, Spreadsheets, and Presentation, which are similar to Microsoft Word, Excel, and PowerPoint.[13] WPS Office for Linux Alpha 18 Patch 1 was released on 11 June 2015.[1]
Kingsoft Office Excel Shortcut Keys Pdf
2014-present[edit]
On June 6, 2014, all Kingsoft Office products were renamed WPS Office.[14]
On December 16, 2014, WPS Office 2014 for Windows, build 9.1.0.4932, was released as a subscription model for a monthly charge of US$3 for some features. The free version provided basic features and supported Microsoft Office .doc, .xls, and .ppt file formats. Premium paid versions provided full compatibility for Microsoft Office files. Officially only the paid 2014 version supported saving files in .docx, .xlsx, and .pptx formats, but, actually, the free version also supported these formats (as had the 2013 free version).[15]
On June 21, 2016, WPS Office 2016 for Windows became generally available as Freemium software, with no subscription needed for basic features.[16]
On 28 May 2017 Kingsoft tweeted that the Linux version was at a halt,[17] but denied this a few days later, removed the tweet, and issued a further alpha version. Kingsoft also tweeted making reference to making WPS Office for Linux open-source towards the end of 2017 to allow the Linux community to step in and continue maintaining it, but later deleted this tweet too.[18]
WPS Office 2019 was released on May 6, 2019. It introduced new integration and personalized features as well as full support for the PDF format.
Editions[edit]
WPS Office has versions for multiple operating systems. It has editions for:
- Windows
- macOS
- Linux (Fedora, CentOS, OpenSUSE, Ubuntu, Mint, Knoppix) — Originally supports both 32- and 64-bit systems, however support for 32-bit systems stopped as of July 2019.[19]
- Android
- iOS
In addition to the above, WPS Office also has a web version.
Versions and subscription model[edit]
WPS Office 2016 is available in Free, Premium, and Professional versions, along with versions for Android and iOS. The free version provides basic features and supports Microsoft Office file formats. Some features, such as printing and mail-merge, can be temporarily accessed only after viewing an advertisement, which WPS Office refers to as sponsored access.[20]
The subscription-based, paid version, called WPS Office 2016 Premium, is available for US$9.99 per 3 months, and makes all features available without viewing advertisements.[21]
A lifetime license for WPS Office 2016 Professional can be purchased for $79.99.[21]
Product Name | Price | Version |
---|---|---|
WPS Office Free | Free | - |
WPS Premium | US$29.99/Year | 10.2.0.7478 |
WPS Home & Student | US$44.99/Year | - |
WPS Office License | US$44.99/Year | - |
File format[edit]
According to an April 2017 review of WPS Office 2016 Free v10.2.0.5871 for Windows, the program opens and saves all Microsoft Office document formats (doc, docx, xls, xlsx, etc.), HTML, RTF, XML, and PDF.[22]
- Text document formats: wps, wpt, doc, dot, docx, dotx, docm, dotm
- XML document formats: xml, htm, html, mht, mhtm, mhtml
- Spreadsheet document formats: et, ett, xls, xlsx, xlt, xltx, csv, xlsm, xltm, xlsb, ets
- Slideshow document formats: ppt, pot, pps, dps, dpt, pptx, potx, ppsx, pptm, potm, ppsm, dpss
See also[edit]
Notes and references[edit]
- ^ abcCurrently in Alpha state. See 'WPS for Linux A15 is Released'. Retrieved 12 June 2015.
- ^'What is WPS Office and. wps File Format - Kingsoft Office'. Ksosoft.com. Retrieved 2014-08-19.
- ^'Kingsoft Office for iOS to hit iPhones and iPads'. Kingsoftstor.com. Retrieved 11 January 2014.
- ^'Download Kingsoft free office app for Android'. Kingsoftstore.com. Retrieved 11 January 2014.
- ^'WPS Office Home Page'. wps.com.
- ^'WPS Office Officially Releases WPS 2016 for Windows'. wps.com.
- ^'WPS Office for Linux Update Available to Download - OMG! Ubuntu!'. OMG! Ubuntu!. 2019-04-02. Retrieved 2019-09-19.
- ^https://www.businesswire.com/news/home/20190910005579/en/Kingsoft-Office-Launches-WPS-Office-2020-UK
- ^'WPS Office Software: free office software, professional office software'. wps.com. Retrieved 11 January 2014.
- ^'Kingsoft WPS Office Receives Further Orders from Central Ministries'. Free Online Library. Kingsoft Office Software Corporation Limited. 19 May 2011. Retrieved 11 January 2014.
- ^https://archive.is/20130128080506/http://www.marketwatch.com/story/kingsoft-corporation-released-three-editions-of-kingsoft-office-2012-2012-02-27
- ^'Kingsoft Office + PDF - FREE!'. Google Play. Kingsoft Office Software Corporation Limited. 31 December 2013. Retrieved 11 January 2014.
- ^'Kingsoft Office 2013 has been released'. Kingsoft Office. Archived from the original on 10 June 2013. Retrieved 22 January 2014.
- ^'Kingsoft Office Change Name to WPS Office'. Kingsoft Office. Retrieved 22 September 2014.
- ^'WPS Office for Windows'. WPS Office. Retrieved 21 December 2014.
- ^'WPS Office Implements Freemium Version of Software'. wps.com. Retrieved 21 June 2016.
- ^Joey Sneddon (28 May 2017). 'Linux Users Shouldn't Expect Further Updates to WPS Office…'. OMG! Ubuntu!. Retrieved 21 July 2017.
- ^Joey Sneddon (31 May 2017). 'Kingsoft Say WPS Office for Linux Will Continue To Be Updated After all'. OMG! Ubuntu!. Retrieved 21 July 2017.
- ^'Downloads - WPS Office Community'. wps-community.org. Retrieved 2019-07-08.
- ^'Why you should take another look at WPS Office Free'. CNet. Retrieved 23 August 2017.
- ^ ab'Compare WPS Office'. WPS Office. Retrieved 23 August 2017.
- ^Mike Williams (15 June 2017). 'WPS Office 2016 Free v10.2.0.5871'. Techworld.com. Retrieved 21 July 2017.
External links[edit]
Wikimedia Commons has media related to WPS Office. |
Retrieved from 'https://en.wikipedia.org/w/index.php?title=WPS_Office&oldid=1019911384'
Jump to: Navigation Shortcuts, Selection Shortcuts, Display Various Objects, Other Shortcuts
![Kingsoft Office Excel Kingsoft Office Excel](/uploads/1/1/8/5/118526369/525101661.png)
Arrow Keys | Movement in Cells |
Ctrl+Home | Move to Beginning of Worksheet |
Ctrl+PgDn | Switches between Worksheet Tabs(Right to Left) |
Ctrl+PgUp | Switches between Worksheet from Left to Right |
Ctrl+Tab | Go to Next Tab |
Ctrl+Shift+Tab | Go to Previous Tab |
Affordable suv 2021 canada. Enter | Moves One Cell down in Selected Cell Range |
Shift+Enter | Moves One Cell Up in Selected Cell Range |
Home | Moves to Cell in Upper Left Corner of Window |
PgDn | Select Cell in Next Screen in Same Column |
PgUp | Select Cell in Previous Screen in Same Column |
Tab | Move one cell to Right |
Shift+Tab | Move one cell to Left |
Ctrl+Arrow Keys | Select All Worksheet |
Shift+PgDn | Select Cell Range from Current Cells to Next Screen of Same Column |
Shift+PgUp | Select Cell Range from Current Cells to Previous Screen of Same Column |
Alt+F11 | Display MS Visual Basic Editor |
F7 | Display Spelling Check Dialog Box |
Alt+F8 | Display Macros Dialog Box to Run,Edit or Delete Macros |
Alt+Space | Display Control Menu from Program Window |
Ctrl+1 | Display Format Cells Dialog Box |
Ctrl+F1 | Display Task Pane on Right Side of Program Window |
Ctrl+G | Display Go to Dialog Box |
Ctrl+H | Display Replace Dialog Box |
Ctrl+F | Go to Find Dialog Box |
Ctrl+P | Display Print Dialog Box |
Ctrl+Shift+= | Display Insert Dialog Box |
Shift+F10 | Display Context Menu of Selected Item |
Ctrl+O | Display Open Dialog Box |
Alt+Enter | Starts New Line in Same Cell |
Backspace | Clears the content of the active cell to reedit cell content |
Ctrl+' | Enters the current time |
Ctrl+; | Enters the current date |
Ctrl+B | Applies or removes bold formatting |
Ctrl+C | Copies the selected cells |
Ctrl+D | Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below |
Ctrl+End | Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column |
Ctrl+Enter | Fills the selected cell range with the current entry |
Ctrl+I | Applies or removes italic formatting |
Ctrl+N | Create New workbook |
Ctrl+K | Displays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks |
Ctrl+S | Saves the active file with its current file name, location, and file format |
Ctrl+Shift+' | Enters the current time |
Ctrl+Shift+; | Enters the current time |
Ctrl+U | Applies or removes underlining |
Ctrl+V | Paste |
Ctrl+W | Closes the selected workbook window |
Ctrl+X | Cuts the selected cells |
Ctrl+Y | Repeats the last command or action, if possible |
Ctrl+Z | Undo |
F1 | Help |
F11 | Insert chart |
F12 | Displays the Save As dialog box to save the file with a different name, type or location |
F2 | Edits the active cell and positions the insertion point at the end of the cell contents |
F4 | Repeats the last action of adding or deleting the Whole Row/Column |
Created by rank17 on 5/29/2017. Last updated by admin on 12/26/2020
5 Comments for 'Kingsoft Spreadsheets 2016'
Comment #5 by dddd Dec 25, 2020 at 11:40 pm Reply
![Kingsoft spreadsheet for windows 10 Kingsoft spreadsheet for windows 10](/uploads/1/1/8/5/118526369/435134296.jpg)
Need shortcut for wrap text
Comment #4 by Arunsanthosh Aug 26, 2020 at 09:56 am Reply
How to apply filter by shortcut Ctrl+Shift+L not working
Comment #3 by syam Jan 8, 2018 at 06:56 am Reply
how to compressing 10 images one time to do any have ?? short cut key
Comment #2 by Govinda Maltare Nov 23, 2017 at 01:06 am Reply
how i can use menu options without using mouse or using keyboard only?
Comment #1 by GANDHI Aug 14, 2017 at 04:42 am Reply
Is there any key board short cut to move between opened workbooks?
Reply #1 ABC Aug 14, 2017 at 12:40 pm
Kingsoft Microsoft Excel
Ctrl+Tab may be